I'd insert two columns (C:D) and separate the data into two pieces:

Select column B.
Data|Text to columns
delimited by space
and plop the output into column C (keep the original data if you want)

Then I could use:
=sumif(d:d,"xs",c:c)

And if I needed that combined cell, I'd recombine columns C and D with a
formula:

=c1&" "&d1
and drag down.

And I'd make sure any updates were in the quantity and type fields--not that
original format.



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.

--

Dave Peterson