Sum based on certain text within a cell

[pmw19800]

Hello

I need a formula that will sum and return based on specific characters…
D39 = Looks at C21 TO C326 specifically looking for (EAT)… and then sums Colum d up

I have entered expected results


Paul

[NeedForExcel]

Hi,

=SUM(IF(LEN(C21:C326)<>LEN(SUBSTITUTE(C21:C326,"EAT","")),D21:D326,0))

or

=SUM(IF(ISNUMBER(FIND("EAT",C21:C326)),D21:D326,0))

Commit using Ctrl+Shift+Enter

[davsth]

seems overcomplicated unless Ive got it wrong!

sumif(c21:c326,"EAT",d21:d326)


or perhaps
sumif(c21:c326,"*EAT*",d21:d326)

[NeedForExcel]

seems overcomplicated unless Ive got it wrong!

I guess I got it wrong.. I though EAT might be a substring of a bigger text string.. Its not mentioned anywhere in the OP, but not sure why I thought that..

[pmw19800]

thanks for your time,


@ Deep Dave (perfect)