How to get SUM of Unique Products

[NauticaX]

I have found a tool on the Internet that I believe does what I need. Its called DigDb. http://www.digdb.com/excel_add_ins/roll_up_pivot_table_subtotal/#A1 I am looking at the part where it can do Sum of Sales by Store. Basically I have a similar concept I am trying to do but I need the sum of Sales to each of the Company. I have ie. in column A the company name.. in column B will be the sales. the company name will repeat a few times depending on how many sales.. I want to get the SUM of each company. Is there anyway I can do this without having to purchase the above tool?

Thanks.

 

[Brian from Maui]

I have found a tool on the Internet that I believe does what I need. Its called DigDb. http://www.digdb.com/excel_add_ins/roll_up_pivot_table_subtotal/#A1 I am looking at the part where it can do Sum of Sales by Store. Basically I have a similar concept I am trying to do but I need the sum of Sales to each of the Company. I have ie. in column A the company name.. in column B will be the sales. the company name will repeat a few times depending on how many sales.. I want to get the SUM of each company. Is there anyway I can do this without having to purchase the above tool?

Thanks.

Using either a Pivot Table or the SUMIF function should do.

 

[SteveO59L]

Use Data, Filter, Advanced Filter, Unique Records to derive a list of the stores and copy this below your source list. Then use a sumif based on the store name to sum the sales value per store.


HTH

 

[NauticaX]

Using SUMIF

Thanks. I did the Unique records and copied the Unique records to another sheet. Now that I have that I will have another column B to use SUMIF function but I cant figure out how to use this function from another sheet and what parameters to put in.

 

[NauticaX]

Sorry to reply so quick. I looked it up and I think I got it working. Thanks!!

 

[Oaktree]

Try:

=sumif('other sheet'!$A$1:$A$100,B2,'other sheet'!$C$1:$C$100)

Where: "other sheet" is the name of the original sheet, A1:A100 is the range of company names, B2 is the first value in your unique list, and C1:C100 is the range of values you'd like to sum.

Then, copy that formula down.

You may also consider Brian's pivot table suggestion for future reference.