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?