Thanks its not quite right. Both formulas are adding all the dates in the
column but not subtracting the dates over the range. It looks right to me
and I have tried typing the dates into the formula but haven't got it yet.
Any ideas?


Todd

"Domenic" wrote:


Try the following formula...

=SUMPRODUCT(--(P5:P86=C88),--(P5:P86<=C89))

Hope this helps!


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=274301