98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Subtotals
Subtotals
Resolved · Low Priority · Version 2003
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
Wed 14 Oct 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Shortcut for deleting all comments in a spreadsheetIf you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by: |
