Using SUMIF with MID function

[2709236]

I want to perform a SUMIF function, but the criteria anchoring the SUMIF is embedded in the middle of a cell.

I'm attaching a sample of the data. I want to SUMIF the vendor names listed in rows 26 to 32 using the values in column G, and find the embedded vendor name in column A. I think you'd use a MID function to find the vendor names, but I'm not sure.

Thanks!

[oldchippy]

Hi,

I've used an helper column J to extract the name, then use SUMPRODUCT to total each account

[2709236]

Thanks very much!

[oldchippy]

Glad to help - thanks for the feedback

[daddylonglegs]

You could also avoid helper columns and use SUMIF with wildcards, e.g. in B26 copied down

=SUMIF(A$4:A$23,"*"&A26&"*",G$4:G$23)