View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default 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