View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tina tina is offline
external usenet poster
 
Posts: 139
Default 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