Thread
:
count date ranges
View Single Post
#
4
Max
Posts: n/a
=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
----
Reply With Quote