SUMIFS (?) with not exact criteria

[Pojzon]

Hey,
I'm trying to find out sum based on name, It's not exactly the same between two columns, amount of rows is not the same either, so I tried to use &"*", but It's not realy working. I can make it work with one criteria, but not with a range of critiries. Perhaps there is other, better formula. I've run out of ideas, any help is greatly appreciated.

[PeteABC123]

In E12

Please Login or Register  to view this content.

Pete

[Pojzon]

Well, that's not exactly what I need because Name2 column will have other names aswell with other amounts and I need to get only sum for names in Name1 column. My Name2 column is a mix of few columns and I want to find out sum of every one of these columns, separately. I hope that I described it clearly.

[63falcondude]

Try this:

=SUMPRODUCT(SUMIF(A2:A14,"*"&D2:D11&"*",B2:B14))

[FDibbins]

or this ARRAY formula...
=SUM(SUMIF(A2:A14,D2:D11&"*",B2:B14))
entered using CTRL SHIFT ENTER
(pretty much the same as 63's

[kuschem]

Hi,
Use below to below to get correct result

Please Login or Register  to view this content.

confirm formula with control+shift +enter

if this helps then click add rep button at the bottom left corner of this post!

[kuschem]

thanks for the rep Pojzon!