| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF Formula for all occurances of X
Cells contain:
0 A B 1 X X1 2 X1 X AD 3 XI MX 4 REX OMTX 5 X M-X TOTAL ? ? I want a TOTAL count of any occurance with the 'X' in it. When I use "X*" in my formula, it does count all X* occurances but when I try "*X*", it does not count any. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting occurances | Excel Discussion (Misc queries) | |||
| Counting Occurances | Excel Discussion (Misc queries) | |||
| countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
| how do I compare occurances of countif of two values | Excel Discussion (Misc queries) | |||
| I a formula that outputs the number of occurances of a specific t. | Excel Discussion (Misc queries) | |||
Threaded Mode
