=COUNTIF(K3:K29,"=0.75")-COUNTIF(K3:K29,"1.25")
or
=SUMPRODUCT(--(K3:K29=0.75),--(K3:K29<=1.25))
will both retrun the same count
--
Regards,
Peo Sjoblom
"cchen212" wrote in
message ...
Hello
I want to count everything in Column K that is either greater than or =
to 75% AND less than or equal to 125%. Is there a way to do this?
This is the formula i used and it works but it seems a bit long
winded.
thanks
=COUNT(K3:K29)-COUNTIF(K3:K29,"<75%")-COUNTIF(K3:K29,"125%")
--
cchen212
------------------------------------------------------------------------
cchen212's Profile:
http://www.excelforum.com/member.php...o&userid=29951
View this thread: http://www.excelforum.com/showthread...hreadid=468131