=Sumproduct(--(Text(Overall!H8:H2200,"mmm/yyyy")=Text(A1,"mmm/yyyy")))

So you want to count dates within a certain month of a certain year.

A1 = start date = 1/1/2009
B1 = end date = 1/31/2009

=SUMPRODUCT(--(Overall!H8:H2200=A1),--(Overall!H8:H2200<=B1))

to calculate more than one date range?

You'll have to provide more detail.

--
Biff
Microsoft Excel MVP


"roy.okinawa" wrote in message
...
Hello,

I use this formula to sumproduct for one date range:

=Sumproduct(--(Text(Overall!H8:H2200,"mmm/yyyy")=Text(A1,"mmm/yyyy")))

I know it reads "text" but it works. What do I need to add to this
formula
in order for it to calculate more than one date range?

Thanks. Roy