Month() counts empty cells?

[Armitage2k]

Hi,

it seems that suddenly (?) my month() formula is returning empty cells as default "1" (= January), screwing up my statistics. I have a raw data list with dates in the DD/MM/YYYY format and need to count the entries per month, therefore am using

Please Login or Register  to view this content.

to do so. But since today it seems to somehow add me all blank cells as well, which it didnt before.

Whats going on? Any alternative?

Thanks,
A2k

[tom1977]

Hi use this
=SUMPRODUCT((IF(B2:B2000<>"",MONTH(Data!B2:B2000)=1,0)*1))
confirmed with CTRL+SHIFT+ENTER

[JosephP]

empty cells count as 0 which is 0 Jan 1900 in excel world
=SUMPRODUCT((Data!B2:B2000<>"")*(MONTH(Data!B2:B2000)=1))
will fix it (no array entry)