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.
Even Excel (Insert|Function|Countif) puts the syntax as
=COUNTIF(A1:A20,"B1").

Help appreciated

Phil

Excel 2003.