COUNTIF - Cell reference

[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

 

[Alan Beban]

=COUNTIF(A:A,">="&B3)

Alan Beban

 

[Raj Singh]

Hello,

Try this:

COUNTIF(A:A;">="&B3)

Excel thinks it is looking for "B3" versus the value in the cell.

HTH,
Raj

AnalysisWorks Inc
Evidence-Based Analytic Consulting
www.analysisworks.net

Download a free Excel Box Plot add-in:
http://www.analysisworks.net/downloads.htm#BoxPlotPro

 

[Pmxgs]

That happens because with the second formula you aren't looking for the
value of the cell b3 but the exact text '>=b3'.