Tue 6 Oct 2009, 16:23Delegate Rebecca said...
Wed 7 Oct 2009, 16:32Trainer Simon said...
RE: Subtotals
Hi Rebecca,
Thank you for your question.
The workbook data must be arranged in columns with headings on the top row.
Step 1: Sort the data by the column you want to add the subtotals to.
Step 2: Click anywhere in the data and choose Data and then Subtotals
Step 3: In the first box choose the column you sorted by. In the second box choose the function you want. In the third box tick the boxes for the fields you want to add the subtotals to(such as salary). Then click ok.
I hope this answers your question.
Regards
Simon
