» Creating Subtotals Summary in Excel 2007
CATEGORY - Excel Subtotals
VERSION - Microsoft Excel 2007
To create subtotals summary:1. Sort the field for which you want to have subtotal summary. In this example, sort the List by Customer Name.
2. Select Data -> Subtotal (in Outline Group).
3. From At each change in dropdown list select Customer Name.
4. In Add subtotal to select the data fields Quantity and Sales.
5. Click OK.
Book Store:
Recommended Books:
- Microsoft Word Version 2002 Inside Out
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- Excel 2002 For Dummies®
No comments have been submitted.
