| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple subtotals
On my boss's monthly credit card report, each expense receives a keycode
(funding source) and object code (type of expense). I need subtotals of each keycode/object code combination. Suggestions? Many thanks. -- m |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple subtotals
Hi,
You may create a pivot table. Drag keycode and object code to the row area and amount to the data area -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Marion J" wrote in message ... On my boss's monthly credit card report, each expense receives a keycode (funding source) and object code (type of expense). I need subtotals of each keycode/object code combination. Suggestions? Many thanks. -- m |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple subtotals
I think this will work and that you are a genius. Many thanks.
-- m "Ashish Mathur" wrote: Hi, You may create a pivot table. Drag keycode and object code to the row area and amount to the data area -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Marion J" wrote in message ... On my boss's monthly credit card report, each expense receives a keycode (funding source) and object code (type of expense). I need subtotals of each keycode/object code combination. Suggestions? Many thanks. -- m |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple subtotals
I think this works and that you are a genius!! Many thanks!
-- m "Ashish Mathur" wrote: Hi, You may create a pivot table. Drag keycode and object code to the row area and amount to the data area -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Marion J" wrote in message ... On my boss's monthly credit card report, each expense receives a keycode (funding source) and object code (type of expense). I need subtotals of each keycode/object code combination. Suggestions? Many thanks. -- m |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple subtotals
Thank you for the feedback
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Marion J" wrote in message ... I think this will work and that you are a genius. Many thanks. -- m "Ashish Mathur" wrote: Hi, You may create a pivot table. Drag keycode and object code to the row area and amount to the data area -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Marion J" wrote in message ... On my boss's monthly credit card report, each expense receives a keycode (funding source) and object code (type of expense). I need subtotals of each keycode/object code combination. Suggestions? Many thanks. -- m |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple subtotals | Excel Worksheet Functions | |||
| Multiple column headings with Subtotals | Excel Discussion (Misc queries) | |||
| Subtotals from multiple columns? | Excel Discussion (Misc queries) | |||
| Subtotals multiple columns | Excel Worksheet Functions | |||
| Subtotals multiple columns | Excel Worksheet Functions | |||
Linear Mode
