multiple subtotals

M

Marion J

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.
 
A

Ashish Mathur

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Like to start using Access 1
Vlookup a subtotal 2
Can I use the subtotal function while a worksheet is protected? 0
Formula to subtotal monthly expense 5
formula to limit expenses to 1 of 2 values 3
VSTO C# add in Outlook.Appointment error 0
subtotal, match? 10
Creating a Function in Excel 2003 2

Top