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.
 
G

Guest

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 problem 2
want to count in two columns; countif (colA=x AND colB=y)? 1
Find >cell_value with COUNTIF. Can't Refer to Cell Value in "quotemarks" 1
CountIF Question 1
Excel function - countif 2
Countif statement using dates 15
How to count a range of number to a given parameter or criteria. 4
COUNTIF problem 4

Top