Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Group & Sum function
I need to do a group and sum for a spreadsheet that looks a bit like this
Company Market #ofDiv Status I need to get the total # of divisions by market for each status. Is there a function/ set of functions that will help me do this? TIA |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Group & Sum function
Probably easiest to use a pivot table. Highlight the data and then select
Data - Pivot Table. The Pivot Table Wizard will pop up. You can either follow the wizard of just hit finish (the default should be good enough). A new sheet will be created with a pivot table on it. Drag the Number of division to the middle and the Status and markets to the left column. Drag the fields around until you get it looking the way you want it to... If you want you can add a format to it to make it look fance by just selecting a format from the pivot table tool bar... -- HTH... Jim Thomlinson "shikarishambu" wrote: I need to do a group and sum for a spreadsheet that looks a bit like this Company Market #ofDiv Status I need to get the total # of divisions by market for each status. Is there a function/ set of functions that will help me do this? TIA |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Group & Sum function
Is there a way to do this without Pivot Table?
TIA "Jim Thomlinson" wrote in message ... Probably easiest to use a pivot table. Highlight the data and then select Data - Pivot Table. The Pivot Table Wizard will pop up. You can either follow the wizard of just hit finish (the default should be good enough). A new sheet will be created with a pivot table on it. Drag the Number of division to the middle and the Status and markets to the left column. Drag the fields around until you get it looking the way you want it to... If you want you can add a format to it to make it look fance by just selecting a format from the pivot table tool bar... -- HTH... Jim Thomlinson "shikarishambu" wrote: I need to do a group and sum for a spreadsheet that looks a bit like this Company Market #ofDiv Status I need to get the total # of divisions by market for each status. Is there a function/ set of functions that will help me do this? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
close workbook without closing excel and stop recursive function | Excel Discussion (Misc queries) | |||
Need Excel Function to FIND Text - Help! | Excel Worksheet Functions | |||
@ and "function not valid" error (Excel 2003) | New Users to Excel | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |