I am trying to do a formula where the criteria changes from row to row.
For example, in the following formula I would like to use a cell's
value instead of "4" or "1":
=COUNTIF(A:A,"<=4")-COUNTIF(A:A,"<=1")
Is there a way to do this? If not, I will give a much larger
explanation of what I am trying to do.
I appreciate the help.
Chris
--
chris2bc
------------------------------------------------------------------------
chris2bc's Profile:
http://www.excelforum.com/member.php...o&userid=29133
View this thread:
http://www.excelforum.com/showthread...hreadid=488535