Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct calculation for January 09
=SUMPRODUCT(--(MONTH('2008'!B3:B2000)=1),--(YEAR(B3:B2000)=2009))
Hi all, I am using the above, but am getting #VALUE! The format the date is typed in, in the main data sheet, is "05 January 2009", but I have also tried 05/01/2009 but to no avail. Can anyone say where I am going wrong? Thanks Tina |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
January 08 is abbrecviated to 8-Jan. Help! | Excel Discussion (Misc queries) | |||
Advance Sumproduct calculation | Excel Worksheet Functions | |||
Sumproduct calculation between two workbooks | Excel Worksheet Functions | |||
January 2006 | Excel Discussion (Misc queries) | |||
returns calculation using sumproduct | Excel Worksheet Functions |