COUNTIF

Shpendi · Aug 16, 2004

Hi All
I Need a COUNTIF function that counts how many dates are
greater than a certain date.
When I give it a cell reference it doesn't work, but it
works when I enter the actual date.

=COUNTIF(D2

300,">01/07/04") Works
=COUNTIF(D2

300,">$D$3") Doesn't work

Any Ideas?
Thanks
Shpendi

Frank Kabel · Aug 16, 2004

Hi
try:
=COUNTIF(D2

300,">" & $D$3)

Shpendi · Aug 16, 2004

Thanks Frank
That Works fine
Is possible to do something like this

=COUNTIF(D2

300,">" & $D$3)And ,"<" & $D$4)

Basically I need to do a count if based on 2 arguments
E.g Counif =>01/07/04 or Blank

Thanks
Shpendi

Frank Kabel · Aug 16, 2004

Hi
one way:
=COUNTIF(D2

300,">" & $D$3) -COUNTIF(D2

300,">=" & $D$4)

or
=SUMPRODUCT(--(D2

300>$D$3),--(D2

300<$D$4))
for the latter one see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Shpendi · Aug 16, 2004

Thanks a Lot
Shpendi

-----Original Message-----
Hi
one way:
=COUNTIF(D2300,">" & $D$3) -COUNTIF(D2300,">=" & $D$4)

or
=SUMPRODUCT(--(D2300>$D$3),--(D2300<$D$4))
for the latter one see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards
Frank Kabel
Frankfurt, Germany

.