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.