Sub totals of expenditure

[mikesmac]

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hello, I would appreciate some help in creating a budget worksheet in Excel 2004. Can someone please put me on track. I copy paste details of expenditure into a worksheet. I would like to create subtotals of different types of expenditure from the full list. Is it possible to create my own list of sub items labels and then assign each cost item from the total list to one of these sub item label, and the resulting total of each cell with an assigned label to be posted on the worksheet? Many thanks in anticipation of your help.
Regards
Mike

 

[John McGhie]

That's the kind of thing a PivotTable is designed for.

See here: http://office.microsoft.com/en-us/excel/CH062528071033.aspx

You can also do it with individual formulas. Check out the SUMIF function
in the Excel help.

But try with a PivotTable fist. If you learn PivotTables, you will not
regret the time you spend: they are extremely powerful!

Cheers

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
Hello, I would appreciate some help in creating a budget worksheet in Excel
2004. Can someone please put me on track. I copy paste details of expenditure
into a worksheet. I would like to create subtotals of different types of
expenditure from the full list. Is it possible to create my own list of sub
items labels and then assign each cost item from the total list to one of
these sub item label, and the resulting total of each cell with an assigned
label to be posted on the worksheet? Many thanks in anticipation of your help.
Regards
Mike

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

 

[mikesmac]

Thanks very much John for your time. I will get stuck in to Pivot tables as advised.
Regards
Mike