Sumproduct counting blanks

[cktoo]

I'm trying to make a sumproduct formula to count the number of entries in a specific month in the E row of the "DATA" sheet, the formula is located in F7 of the "Res" Sheet, the month to be searched would be typed in G2 of the "Res" Sheet.
My problem is that when I try to type 1 in G2 it counts all the blank cells as well.
This is the formula I'm using
=SUMPRODUCT(1*(MONTH(DATA!E5:E50)=G2))

 

[Fluff]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=SUMPRODUCT((MONTH(DATA!E5:E50)=G2)*(DATA!E5:E50<>""))

 

[cktoo]

Hi, I updated my info, thank you for the tip.
The formula above worked, I may have misstyped it in my early tries, it always ended with te error "spill"
Thank you very much.

 

[Fluff]

Glad to help & thanks for the feedback.