Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Totalling unique values
I have a list with the following
Cust Qty A 1 B 2 A 2 C 1 How can I subtotal Quantities for each customer? (i.e. Cust A should subtotal 3) I have already used the Advanced Filter to pull out the unique customer ID's I just don't know how to get the subtotal for each. |
#2
|
|||
|
|||
Hi Stumped,
Fist thing is to sort the list by customer number. Then go to datasub totals at each change in CustsumQty. You will get a sub total and a grand total. HTH ray "Stumped" wrote: I have a list with the following Cust Qty A 1 B 2 A 2 C 1 How can I subtotal Quantities for each customer? (i.e. Cust A should subtotal 3) I have already used the Advanced Filter to pull out the unique customer ID's I just don't know how to get the subtotal for each. |
#3
|
|||
|
|||
Hi,
Assume Cust is in col A:A and Qty in B:B. In C2: =SUMIF(A:A,A2,B:B) Regards, A "Stumped" wrote: I have a list with the following Cust Qty A 1 B 2 A 2 C 1 How can I subtotal Quantities for each customer? (i.e. Cust A should subtotal 3) I have already used the Advanced Filter to pull out the unique customer ID's I just don't know how to get the subtotal for each. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) | |||
Count Unique Values | Excel Worksheet Functions | |||
Count number of Unique values | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |