Thread: How to reference a cell

I need who can explain why the following works...

=COUNTIF(D10:D374,">149")

But the following does not...

=COUNTIF(D10:D374,">B5")
nor does...
=COUNTIF(D10:D374,>B5)

If I specify just the cell B5 it works, and it works if I include the > symbol in the cell, but with the greater than operator in the formula it does not work when used as a criteria.

All cells are formatted as NUMBER.

I want to use the cell reference in the formula, as it would be easier to change it in that one location rather than 80 or so locations throughout a couple of sheets in the workbook.

Mike

I think you'll find that this works

=COUNTIF(D10:D374,">" & B5)

Cheers!