Oh, now I get it.
=SUM(LEN(B1:B30)-LEN(SUBSTITUTE(B1:B30,"xs","")))/2
Note: this is a CSE function; use Ctrl+Shift+Enter, not just Enter.

HTH,
Ryan--
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"ryguy7272" wrote:

=SUMPRODUCT(--(B1:B30="x"))
=COUNTIF(B1:B30,"x")

HTH,
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"ahuey" wrote:

Ex. In Column B there are 30 cells. I need to know the total of the numbers
with xs. I do not need to know the total of cells that have the text xs in it.
Cell 1 has 2 xs (xsmall)
Cell 2 has 3 s (small)
Cell 3 has 2 s
Cell 4 has 3 xs
Cell 5 has 1 xs
I need to know the total of xs is 6. I keep getting 3 or zero. I need to
know what formula to use. Then I can use the same formula to get the total of
s. Please help.