want formula

[Harish Kumar]

In MS Excel the formula "=COUNTIF(B1:B6,A7)" gives us the
number of cells from B1 to B6 which contains the string
matching with the string in the cell A7.
eg: if A7 contains 20 ; B1 and B2 contains 20 ;B3 to B6
contains other than 20 ,this formula return 2.
The question is if i want to see the number of cells
which contain the number equal to or more than 20,what
modification i should make to the formula?

 

[Cecilkumara Fernando]

Harish,
Just change A7 from 20 to >19 or >=20
or change the formula to
=COUNTIF(B1:B6,">=20")
Cecil

 

[Norman Jones]

Hi Harish,

Try:

=COUNTIF(B1:B6,">="&A7)