Count date occurrence, mine code doesn't work

[most]

Hello!
Can anyone help me explain what's wrong here and how to solve it?

{=SUM(IF(MONTH(named_range)=C3,1))}

My expectation is that the code should count occurrence of a specific month of the dates in the green field(named_range).
Month 2-12 works fine, but month 1 return the number of rows in the named range minus occurrence of the other months, in this case 6.

If there is a better way to solve it, i'm all ears.

regards Marcus

 

[Fluff]

Try
=SUM(IF((MONTH(DRng)=C3)*(DRng<>""),1))
Your formula is adding the blank cells to January

 

[Rick Rothstein]

Here is another formula (normally entered) that you can consider...

=SUMPRODUCT(--(MONTH(named_range)=C3),--(named_range<>""))

 

[most]

...and of course, both of them works perfectly. Thanks! Case closed.

 

[Fluff]

Glad we could help & thanks for the feedback