Lookup and SUM

[len3121]

Hi,

I'm looking for some help on creating a formula. I'm guessing there is a way to do what I want using Lookup and SUM, but I am at a loss as to how to actually accomplish it.

I have a product spreadsheet. Column A has the handle (unique identifier) of each product. The handle will appear in as many rows as there are sizes so if for example there was a S, M, L in a particular product the same handle would appear in A1, A2 and A3. Column L (L1,L2,L3) has the quantity of each size.

Is there a way to write a formula that will add all the quantities for each handle up and end up with a sheet that just lists each handle once with the total quantity available?

So instead of:
handle1 - 1
handle1 - 2
handle1 - 1
handle2 - 4
handle2 - 3

I would get something like
handle1 - 4
handle2 - 7

The other columns in the sheet are not absolutely necessary for this task and can be deleted if required.

Any help would be appreciated.

Thanks!

 

[mrshl9898]

Sounds like you need SUMIF

=SUMIF(A:A,"handle1",L:L)

Just swap out "Handle1" for whatever cell contains that text.

 

[len3121]

Yup, that did the trick. Thank you so much for your help! You saved me hours of going through thousands of rows and adding things up manually.