Use the & operator to combine the operator you want (<=) with the cell
reference containing the value: =COUNTIF(A:A,"<="& F2)
--Bruce
"chris2bc" wrote:
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