SUMPRODUCT Trouble

[Paiwand]

Hello Dear,

i use the below formula to get the count number of the specific cells based on month which are exist on the E column, it works correctly but while it face any cell that contains formula without result it will be (#Value) please your help to avoid this and only consider the dates and leave any others.

B2=SUMPRODUCT(--(MONTH($E$4:$E$13)=1)) it should be 3

E

[TABLE="width: 103"]
<colgroup><col></colgroup><tbody>[TR]
[TD]01 January[/TD]
[/TR]
[TR]
[TD]12 January[/TD]
[/TR]
[TR]
[TD]23 January[/TD]
[/TR]
[TR]
[TD]03 February[/TD]
[/TR]
[TR]
[TD]14 February[/TD]
[/TR]
[TR]
[TD]25 February[/TD]
[/TR]
[TR]
[TD]=formula and no result (it shows as blank)[/TD]
[/TR]
[TR]
[TD]19 March[/TD]
[/TR]
[TR]
[TD]30 March[/TD]
[/TR]
</tbody>[/TABLE]

Best regards,

 

[Eric W]

Maybe:

=SUMPRODUCT(--(TEXT($E$4:$E$13,"mmm")="Jan"))

 

[Paiwand]

thank you so much