A problem about the function COUNTIF

[Chris]

Dear all,

I encountered a problem when I use the function COUNTIF.
Column A (A1: A1000) is a column of numbers and B1 is another number. I
would like to record how many entries in column A is bigger than B1 in
another cell C1. I tried to use the formula

=COUNTIF(A1:A1000,">B1")

for C1 but it failed. However, the formula

=COUNTIF(A1:A1000,">0")

shows the number of positive entries in column A correctly. It seems that
the function cannot recognize >B1 as a selection criteria. May I know how it
can be solved? Thanks in advance.

Best Regards,
Chris

 

[Dave Peterson]

Try:
=COUNTIF(A1:A1000,">"&B1)

Inside the quotes, you're actually looking for the Characters B1--not the value
that's in that cell.