LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
create list of unique values from a column with repeated values? Chad Schaben Excel Worksheet Functions 1 July 8th 05 10:25 PM
Extract Unique Values, Then Extract Again to Remove Suffixes Karl Burrows Excel Discussion (Misc queries) 23 June 25th 05 10:37 PM
Count Unique Values annie Excel Worksheet Functions 1 June 9th 05 07:19 AM
Count number of Unique values Alan Excel Worksheet Functions 4 January 6th 05 08:05 PM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 12:25 AM


All times are GMT +1. The time now is 09:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"