Hi, guys,
I have a Range A1:A10 with the following:
A1 - 01-Jan
A2 - 02 -Jan
A3 - 01-Feb
A4 - 02-Feb
A5 (Blank)
A6(Blank)
A7(Blank)
A8 - 03-Jan
A9(Blank)
A10(Blank)

If I want to count how many cells have "Jan" with the formula:
=SUMPRODUCT(--(TEXT($A$1:$A$5;"mmm")="Jan"))

it gives me the number 8. However, really the number is 3.
But, if the above formula is with "Feb", the number is correct, i.e. - 2.

I understood that for unknown reason to me, the first formula counts the
blank cells as they are with "Jan" too. So, if I write:
=SUMPRODUCT(--(TEXT($A$1:$A$10;"mmm")="Jan"))-SUMPRODUCT(--ISBLANK(A1:A10))
the result is now correct, I mean, number 3.

Any ideas for this? Thanks in advance.

--
JRod