On Friday, February 13, 2015 at 9:13:33 AM UTC-8, Claus Busch wrote:
Hi Howard,

Am Fri, 13 Feb 2015 09:03:25 -0800 (PST) schrieb L. Howard:

Columns E and F. (Text is all in one cell in column E)

AA BB CC 1
QQ WW EE 2
AA SS DD 3
AA BB CC 4
QQ WW EE 5
AA SS DD 6
AA BB CC 7
How do I sumif for the cells that have AA & CC which would return 12?

try:
=SUMIF(E1:E7,"AA*CC",F1:F7)
=SUMIFS(F1:F7,E1:E7,"AA*",E1:E7,"*CC")



Regards
Claus B.

Interesting. Would have never figured that out and I am suprised how little I could find on how to look for two "XX"'s in a cell.

I suppose one could expand to three...?

I'll play with that to see.

Thanks Claus.

Howard