COUNTIF oddity

P

Phil C

Hi All

Im sure this must be very simple but..
I have got a column of integer numbers (formatted general), say A1:A20
I just want to count the number of cells with values greater than a certain
figure (integer stored in a different cell, say B1)
But =COUNTIF(A1:A20,">B1") incorrectly returns a value of zero.
=COUNTIF(A1:A20,>6) works OK .....as does =COUNTIF(A1:A20,B1), but I want
B1.
Click to expand...
Even Excel (Insert|Function|Countif) puts the syntax as
=COUNTIF(A1:A20,">B1").

Help appreciated

Phil

Excel 2003.
 
M

Mike H

Phil,

Try:-

=COUNTIF(A1:A20,">"&B1)

Mike

Phil C said:
Hi All

Im sure this must be very simple but..
I have got a column of integer numbers (formatted general), say A1:A20
I just want to count the number of cells with values greater than a certain
figure (integer stored in a different cell, say B1)
But =COUNTIF(A1:A20,">B1") incorrectly returns a value of zero.
=COUNTIF(A1:A20,>6) works OK .....as does =COUNTIF(A1:A20,B1), but I want
Even Excel (Insert|Function|Countif) puts the syntax as
=COUNTIF(A1:A20,">B1").

Help appreciated

Phil

Excel 2003.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif 2
Find >cell_value with COUNTIF. Can't Refer to Cell Value in "quotemarks" 1
Countif problem 2
CountIf Not Multiple 6
Excel function - countif 2
How do I get started using the Countif, Countifs option with Excel 2
Countif(and 2
If Function neglecting 0 as a number 1

Top