|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 11th, 2009, 02:09 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I select cells for a specific month in Excel 2003?
-- Many Thanks HelplessIdiot 
|
|
#2
May 11th, 2009, 03:05 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I select cells for a specific month in Excel 2003?
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))))) -- Many Thanks HelplessIdiot "HelplessIdiot" wrote: -- Many Thanks HelplessIdiot
|
|
#3
May 11th, 2009, 03:30 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I select cells for a specific month in Excel 2003?
HelplessIdiot wrote:
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))))) The month test would go something like this: IF(MONTH(cell:range)=1,...
|
|
#4
May 11th, 2009, 03:35 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I select cells for a specific month in Excel 2003?
Glenn wrote:
HelplessIdiot wrote: 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))))) The month test would go something like this: IF(MONTH(cell:range)=1,... 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)))))
|
|
#5
May 12th, 2009, 07:15 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I select cells for a specific month in Excel 2003?
-- Many Thanks HelplessIdiot "Glenn" wrote: Glenn wrote: HelplessIdiot wrote: 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))))) The month test would go something like this: IF(MONTH(cell:range)=1,... 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))))) Glen Thanks very much - that did the trick Many Regards Ed
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
