View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
L. Howard L. Howard is offline
external usenet poster
 
Posts: 852
Default 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