» 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:
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Understanding Financial Statements
- Marketing Plans That Work, Targeting Growth and Profitability
- Keys to Reading an Annual Report (Barron's Business Keys)
No comments have been submitted.
