CountIf function

  • Thread starter Thread starter Colin Macleod
  • Start date Start date
C

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
 
-----Original Message-----
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
Click to expand...
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
 
=COUNTIF(A1:A200,">"&A201)
Peter atherton said:
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
Click to expand...
 
Back
Top