want formula
 

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?

want formula
 

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

"Harish Kumar" wrote in message
...
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?

want formula
 

Hi Harish,

Try:

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

---
Regards,
Norman



"Harish Kumar" wrote in message
...
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?