Variable Criteria?

C

chris2bc

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
 
B

bpeltzer

Use the & operator to combine the operator you want (<=) with the cell
reference containing the value: =COUNTIF(A:A,"<="& F2)
--Bruce
 
Top