Variable Criteria?

[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

 

[Guest]

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

 

[chris2bc]

Ah! Thank you Bruce! Worked like a charm!

--Chris