SUMIF Wild Card formula for two words in cell
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
=SUMIF(E1:E7,"AA*",F1:F7) returns 21
How do I sumif for the cells that have AA & CC which would return 12?
Howard
|