| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF Formula for all occurances of X
I used this equation with no problem
=COUNTIF(B26:B31,"*X*") "YanYan" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF Formula for all occurances of X
=countif(a1:A5,"*x*")
gives you 0?????? It gives me a count of the number of cells that contain at least one X. YanYan wrote: 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. -- Dave Peterson |
| Reply |
| 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) | |||
Hybrid Mode
