How can I reference a cell as the criteria in a count if function.

R

RobA

trying to use "countif" function and have the criteria as a formulated cell,
any ideas on how to make it recognize criteria as a cell reference and not a
value?
 
B

bj

not sure what you did, but don't put the quotes around the cell reference
for example
=countif(A1:A200,"<="&B1)
to count values less than or equal to B1
 
Top