| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need help with formula
I have a range of cell I want to count ,,say the 2's but with this formula
,,,,=SUMPRODUCT(--(ISNUMBER(FIND("2",G18:G41)))) I count not only the 2's by them selfs but also the 2's in 22 or 12 etc..giving me the wrong results... Also I want to count the 2's only if this range of cells,,,,, N18:O41 has 4A entered into it... can some one help. slow hand |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Threaded Mode
