Count instances in a month and ignore blanks

[tobysdhc]

Hello,

I am using the formula below to count the number of incidents in the month of January

=SUMPRODUCT(1*(MONTH('Data Sheet'!$P$2:$P$1009)=1))

There are only about 30, but it is returning 900. It seems to be counting blanks as January.

Is there a way blank cells can be ignored?

Thank you,

 

[Fluff]

How about
=SUMPRODUCT(('Data Sheet'!$P$2:$P$1009<>"")*(MONTH('Data Sheet'!$P$2:$P$1009)=1))

 

[tobysdhc]

=SUMPRODUCT(('Data Sheet'!$P$2:$P$1009<>"")*(MONTH('Data Sheet'!$P$2:$P$1009)=1))

That did it! thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback