Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count unique values - Pivot Table | Charts and Charting in Excel | |||
Search multiple values to return single values | Excel Worksheet Functions | |||
Count unique values and create list based on these values | Excel Worksheet Functions | |||
Number of unique attributes that multiple people have | Excel Discussion (Misc queries) | |||
Can you paste values on multiple worksheets at one time? | Excel Worksheet Functions |