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

01 January

12 January

23 January

03 February

14 February

25 February

=formula and no result (it shows as blank)

19 March

30 March

<colgroup><col></colgroup><tbody>
</tbody>

Best regards,

 

[Eric W]

Maybe:

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

 

[Paiwand]

thank you so much