SUM range Based On RANGE cells Contents

[onp]

Hello,
I am Having difficulties creating a formula that sums the "Amount" column based on the content of all cells in "Description" range.

Not sure if it is possible.

I have attached a sample with in it a brief description of the criteria that I am looking for.

Thank you in advance for your Help
Cheers
ONP

[Pete_UK]

You can use wildcard characters with SUMIF, so try this in H3:

=SUMIF(C5:C18,"/MES*",E5:E18) + SUMIF(C5:C18,"/ES*",E5:E18)

Hope this helps.

Pete

[etaf]

you can use a SUMIF() with wild cards
=SUMIF(C5:C18,"/MES*mark to market*",E5:E18)
if you want to add both possible text strings
you could add together
=SUMIF(C5:C18,"/MES*mark to market*",E5:E18)+SUMIF(C5:C18,"/ES*mark to market*",E5:E18)
you say OR

I Would Like to Sum Column "E" Based on If Cells in RANGE "C5:C18" contain certain text.
Such as "/MES" & "mark to market"
Or Such as "/ES" & "mark to market"
and Exclude all other values
The relult would appear in Cell H3
Hope its possible
Thank you

[onp]

Thank you Very Much Etaf and Pete
I never knew about placing the asterix between quotes.
The missing asterix was the little culprit causing my formulas to fail.

Much appreciated your help

Cheers
Nino

[Pete_UK]

Glad to help, and thanks for the rep and for marking the thread as Solved.

If the text you are looking for might be embedded anywhere in the strings in column C, you can also use the asterisk before as well as after the text, i.e. "*/MES*", which means any number of characters before, then /MES, and any number of characters after.

Hope this helps.

Pete