Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |