Alternative to summing nested If's

**mashley** · 10-08-2009, 03:53 PM

I have a table of approx 20k customers (column A) and their $ sales (column B)for a time period. I need to sum the sales of approx 50 customers. I have the names of the 50 customers to be summed in one column so i can reference them and easily change out a customer if need be. Can anyone suggest an alternative to creating a nested sum that repeats 50 times? I can not change the source data at all, so I have to pull the data into anther area. Thanks.

**JBeaucaire** · 10-08-2009, 03:55 PM

You want a SUMIF() formula.

Ref Names - column A
Ref Values - column B

Names to Sum - column C
Formulas - Column D

If the first name is in C2, put this in D2 and copy down:

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

**mashley** · 10-08-2009, 04:02 PM

Thanks for the quick response.
My fault for not specifying...I would like the summed result of all 50 customers in one cell, preferably without the intermediate step of sumif next to each customer.

**JBeaucaire** · 10-08-2009, 06:23 PM

How about this:

=SUM(SUMIF(A:A, C1:C50, B:B))

...or even:
=SUM(SUMIF(A:A, C:C, B:B))

I wouldn't use a LOT of those in your sheet.

**mashley** · 10-09-2009, 08:38 AM

thanks for the help.

**JBeaucaire** · 10-09-2009, 09:37 AM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)