Hi
what is the formula you have tried?
Both formulas should work
--
Regards
Frank Kabel
Frankfurt, Germany
Todd wrote:
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