COUNTIF - Cell reference

  • Thread starter Thread starter Fredrik
  • Start date Start date
F

Fredrik

Hi!
I have a function COUNTIF(A:A;">=35000") that works well. But when I try to
use a cell reference it doesn´t work, like COUNTIF(A:A;">=B3")

Anyone have an idea?

Thanks in advance!
/Fredrik
 
That happens because with the second formula you aren't looking for the
value of the cell b3 but the exact text '>=b3'.
 
Back
Top