multiple subtotals

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

 

[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

 

[Marion J]

I think this will work and that you are a genius. Many thanks.

 

[Marion J]

I think this works and that you are a genius!! Many thanks!

 

[Ashish Mathur]

Thank you for the feedback

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

I think this will work and that you are a genius. Many thanks.