Hi,

What exactly do you mean by more than one date range?


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"roy.okinawa" wrote:

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