sumproduct help

[IneedHelplol]

Col A contains strings, col B contains numbers.

abc 2
abc 3
acb 1

Add the values in col B for every "abc" in col A in the same row. In this example the answer would be 5.

abc 2
abc 3
-------
5

edit: The search value (in this case abc) will be in another cell in the same worksheet (F5).

Thanks

[NBVC]

=Sumproduct(--(A1:A3="abc"),B1:B3)

adjust ranges to suit

or better:

=Sumif(A1:A3,"abc",B1:B3)

[oldchippy]

Hi

Welcome to the forum, please take time to read the rules, and here is an answer for you

=SUMPRODUCT(--(A1:A3="abc")*B1:B3)

[IneedHelplol]

Sorry, I forgot to add that the strings in col A must match a pattern in cell F5 not just a specific string. So if F5 contained *a*b*c* it would match abc aLbLc and a1b2c etc in col A and add the values fin col B together for the strings that matched in col B.

Original posting

Figured it out

Thanks for the help.

[NBVC]

Instead of changing your posting... please repost the revised question and supply the solution you got.

This may help future users with similar problem.

[NBVC]

Since you didn't bother to post your original revised question (oldchippy did it for you) and you didn't supply your own solution... I assume your solution was to simply use Sumif() since the "*" in F5 indicate wildcards...

e.g. =Sumif(A:A,F5,B:B)

This would find all instances of strings in column A containing the letters "a", "b" and "c" separated by any other characters...and it would sum corresponding values in columnB