You're right Max.<g
BUT, I also forget, as you *didn't*, to include the possibility that the
entire referenced range might not be completely populated, and therefore
return an incorrect answer.
=SUMPRODUCT((TEXT($A$1:$A$25,"mmm")=B1)*($A$1:$A$2 5<""))
--
Regards,
RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------
"Max" wrote in message
...
=SUMPRODUCT(--(TEXT(A1:A25,"mmm")=B1))
Neater !
... but think the range A1:A25 needs to be fixed: $A$1:$A$25
before copying down from C1 <g
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
|