| 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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Threaded Mode
