CountIf function

[Colin Macleod]

I'm trying to use countif to count the number of values in a range that are
greater than the value in another cell. For example,
countif(a1:a200,>a201) - but this gives an error message. How do I get round
this? I know it will work if I enter the value in the cell i.e.
countif(a1:a200,">3456") , but I don't want to do this.
Help gratefully received.

Thanks

Colin Macleod

 

[Alan]

=COUNTIF(A1:A200,">"&A201)

Colin

=COUNTIF(B1:B5,C1) works providing that the value in C1
has the greater then sign as well as the number e.g. >20

Also the array formula =COUNT(IF(B1:B5>c1,B1:B5)) works
without the > in the cell. Enter this formula as an array
(Ctrl + Shift + Enter)

Regards
Peter