» Creating Subtotals Summary in Excel 2007
CATEGORY - Excel Subtotals
VERSION - Microsoft Excel 2007
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:
- Marketing Management
- The 22 Immutable Laws of Branding
- Business Analysis with Microsoft Excel (2nd Edition)
- Microsoft Windows XP Registry Guide
- Marketing Plans That Work, Targeting Growth and Profitability
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
No comments have been submitted.
