Inclusive between count:

=COUNTIF($P$5:$P$86,"="&C88)-COUNTIF($P$5:$P$86,""&C89)

Todd Wrote:
Hi I am tring to count how many entries I have between two dates. I
have
been trying to use the countif function and can't get greater or less
thans
to work with it.

My dates are in cells c88 (lowest to count) and c89 (highest to
count).
The data is in column P

Also, I will need to do the same counting of dates but in two columns
instead after this is figured out.

=COUNTIF(P5:P86,C88) is what I have and of course its not right at
all.


TIA

Todd


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=274301