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

Sum multiple Unique Values in col
 

Hi

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

Andy.

"DanB" wrote in message
...
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

Sum multiple Unique Values in col
 

On Mon, 23 Jan 2006 08:17:04 -0800, "DanB"
wrote:

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