Multiple sumifs with variable conditions

Hey,

I have a problem I can't solve.
I have a spreadsheet with Data from our warehousing software.

A product has stock in multiple locations, it can be 1 but it can be 6 locations as well.
For each location there is a line with the article number an the stock at the location.
I now need to get the overall sums of each article.

List looks like this:

A | 2
A | 3
B | 1
B | 2
B | 3
B | 2
C | 0
C | 1

What I want is:

A | 2 | 5
A | 3 | 5
B | 1 | 8
B | 2 | 8
B | 3 | 8
B | 2 | 8
C | 0 | 1
C | 1 | 1

I hope you guys can help me out :-)

Hello and welcome to the forum.

Assuming that your data is in columns A and B starting in row 1, in C1, try this:

=SUMIF(A:A,A1,B:B)

thanks falcondude, that did the trick!

You're welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.