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

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?

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

"RobA" wrote:

> 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?