View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marion J Marion J is offline
external usenet poster
 
Posts: 3
Default 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