Sumif Using a Find Formula

[dgh71]

Hi,

Need to do a SUMIF depending on whether a word is found in a column using a FIND formula. So it would be something like this:

=sumif(A:A,(FIND("Coles","A:A)), B:B)

I am unsure how to put the FIND in and redirect it to the ROW.

Any help would be much appreciated

Cheers
Dave

 

[Andrew Poulsom]

Welcome to MrExcel.

Is this what you want?

=SUMIF(A:A,"*Coles*",B:B)

 

[dgh71]

Thanks, that works brilliantly.