Sum multiple Unique Values in col

[DanB]

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

 

[Guest]

Hi

The easiest way to do this is with a pivot table. They are designed for
summarising.
Have a look here:
http://peltiertech.com/Excel/Pivots/pivotstart.htm
for an introduction.

Andy.

 

[Ron Rosenfeld]

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

Use a Pivot Table

Data/Pivot Table


Drag Accoun #'s to the Row area and Number of orders to the Data area.

Format to taste.


Sum of NumOrders
Account Total
22000015 10
22000023 1
22000049 2
22000074 10
Grand Total 23



--ron