Countif function problem

[Carole]

Hi everyone
I have a problem with the countif function, when trying to use a cell reference in the function.
The countif function works fine if using a number.
Example : =Countif(A1:A4;>4) works fine
but
Example :
=Countif(A1:A4;">B1")
does not work.

Please take a look at the file.
Thank you so much!
Carole

 

[bosco_yip]

Try this :

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

Regards
Bosco

 

[Carole]

Wow!!! I am very happy! Thank you so much.
I have looked at hours of youtube video, and some of the did use the ampersand, but not in this manner.
Thanks! Have a great day!

 

[Carole]

Try this :

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

Regards
Bosco

Thank you! You made my day!

 

[Hui]

Carole

Firstly, Welcome to the Chandoo.org Forums

Anything inside the " 's is treated as text
and so =Countif(A1:A4;">B1")
reads Countif A1:A4 is greater than the text value "B1"
ie: "B2" is > "B1"

where =Countif(A1:A4;">"&B1)
reads Countif A1:A4 is greater than the value in cell B1

 

[Carole]

Thank you!