98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Subtotals
Subtotals
Resolved · Low Priority · Version 2003
Graham has attended:
Excel Intermediate course
Excel Advanced course
Subtotals
Is there an easy way to generate sub totals from a list of numbers?
RE: Subtotals
Hi Graham,
Thank you for your post, welcome to the forum, to generate sub totals you first need to sort your list into relevant sections, ie Years, Items, etc. Once you have sorted your list you can then apply subtotals to your sections, follow these steps to apply either Max (highest), Min (lowest), Average, Count of Entries, or Total value of each section;
Data>Subtotals, select the column to subtotal by, then the type of subtotal value, (see above), which column/s you want to view the subtotal/s of and continue following the steps to complete.
Hope that helped, regards Pete
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:Select Single Data MarkerTo select a single data marker in a chart, ie line, bar or column; |