View Single Post
  #1   Report Post  
Stumped
 
Posts: n/a
Default 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.