Thanks, Here is the formula I am trying.

=COUNTIF($P$11:$P$40,"="&9/1/4)-COUNTIF($P$11:$P$40,"<"&9/30/4)

"Frank Kabel" wrote:

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