View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DanB
 
Posts: n/a
Default Sum multiple Unique Values in col

I have a spreadsheet that looks like this:
Account # of
# Orders
22000015 1
22000015 1
22000015 1
22000015 1
22000015 1
22000015 2
22000015 3
22000023 1
22000049 2
22000074 1
22000074 1
22000074 1
22000074 1
22000074 1
22000074 1
22000074 1
22000074 1
22000074 2


I want to auto sum the # of orders for each account so I get a result that
looks like

22000015 10
22000023 1
22000049 2
22000074 10

can anyone assist?

Thanks - dan