» Summing Subtotals Only from Range
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
Column A contains three groups of numbers (cells A2:A4, A7:A9, A12:A14).
Cells A5, A10 and A15 contain SUBTOTAL formulas, which total the numbers to each group.
How can we sum the subtotals values only?
Solution:
Use the SUBTOTAL function to sum each group in the range, then use the SUBTOTAL function to sum the subtotals values as shown in the following formula:
=SUBTOTAL(9,A:A)
Book Store:
Recommended Books:
- Accounting and Financial Fundamentals for Nonfinancial Executives
- Special Edition Using Microsoft Office XP
- East of Eden (Oprah's Book Club)
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- The Total Money Makeover. : A Proven Plan for Financial Fitness
No comments have been submitted.

