How do I select cells for a specific month in Excel 2003?

  • Thread starter Thread starter HelplessIdiot
  • Start date Start date
To expand this as the question was poorly put


I have a spreadsheet with multiple worksheets, and am trying to count
entries in a given month that were completed after an agreed completion date.

I am starting with one of the sheets, but cannot find a function that will
allow me to count all 'January' entries. They all have a 'Date Raised' entry
in UK format. i.e 12-Jan-09 from 12/01/09.

My current failing array formula is as follows

=SUM(IF('Closed RFD Log'!E93:E400=MONTH(1),(IF('Closed RFD
Log'!I93:I400="Funded",IF('Closed RFD Log'!N93:N400>'Closed RFD
Log'!P93:P400,1,0)))))
 
To expand this as the question was poorly put


I have a spreadsheet with multiple worksheets, and am trying to count
entries in a given month that were completed after an agreed completion date.

I am starting with one of the sheets, but cannot find a function that will
allow me to count all 'January' entries. They all have a 'Date Raised' entry
in UK format. i.e 12-Jan-09 from 12/01/09.

My current failing array formula is as follows

=SUM(IF('Closed RFD Log'!E93:E400=MONTH(1),(IF('Closed RFD
Log'!I93:I400="Funded",IF('Closed RFD Log'!N93:N400>'Closed RFD
Log'!P93:P400,1,0)))))
 
HelplessIdiot said:
To expand this as the question was poorly put


I have a spreadsheet with multiple worksheets, and am trying to count
entries in a given month that were completed after an agreed completion date.

I am starting with one of the sheets, but cannot find a function that will
allow me to count all 'January' entries. They all have a 'Date Raised' entry
in UK format. i.e 12-Jan-09 from 12/01/09.

My current failing array formula is as follows

=SUM(IF('Closed RFD Log'!E93:E400=MONTH(1),(IF('Closed RFD
Log'!I93:I400="Funded",IF('Closed RFD Log'!N93:N400>'Closed RFD
Log'!P93:P400,1,0)))))
Click to expand...


The month test would go something like this:

IF(MONTH(cell:range)=1,...
 
HelplessIdiot said:
To expand this as the question was poorly put


I have a spreadsheet with multiple worksheets, and am trying to count
entries in a given month that were completed after an agreed completion date.

I am starting with one of the sheets, but cannot find a function that will
allow me to count all 'January' entries. They all have a 'Date Raised' entry
in UK format. i.e 12-Jan-09 from 12/01/09.

My current failing array formula is as follows

=SUM(IF('Closed RFD Log'!E93:E400=MONTH(1),(IF('Closed RFD
Log'!I93:I400="Funded",IF('Closed RFD Log'!N93:N400>'Closed RFD
Log'!P93:P400,1,0)))))
Click to expand...


The month test would go something like this:

IF(MONTH(cell:range)=1,...
 
Glenn said:
The month test would go something like this:

IF(MONTH(cell:range)=1,...
Click to expand...


I guess that could have been confusing...

=SUM(IF(MONTH('Closed RFD Log'!E93:E400)=1,
(IF('Closed RFD Log'!I93:I400="Funded",
IF('Closed RFD Log'!N93:N400>'Closed RFD Log'!P93:P400,1,0)))))
 
Glenn said:
The month test would go something like this:

IF(MONTH(cell:range)=1,...
Click to expand...


I guess that could have been confusing...

=SUM(IF(MONTH('Closed RFD Log'!E93:E400)=1,
(IF('Closed RFD Log'!I93:I400="Funded",
IF('Closed RFD Log'!N93:N400>'Closed RFD Log'!P93:P400,1,0)))))
 
--
Many Thanks

HelplessIdiot


Glenn said:
I guess that could have been confusing...

=SUM(IF(MONTH('Closed RFD Log'!E93:E400)=1,
(IF('Closed RFD Log'!I93:I400="Funded",
IF('Closed RFD Log'!N93:N400>'Closed RFD Log'!P93:P400,1,0)))))
Click to expand...

Glen

Thanks very much - that did the trick

Many Regards

Ed
 
--
Many Thanks

HelplessIdiot


Glenn said:
I guess that could have been confusing...

=SUM(IF(MONTH('Closed RFD Log'!E93:E400)=1,
(IF('Closed RFD Log'!I93:I400="Funded",
IF('Closed RFD Log'!N93:N400>'Closed RFD Log'!P93:P400,1,0)))))
Click to expand...

Glen

Thanks very much - that did the trick

Many Regards

Ed
 
Back
Top