» Summing Subtotals Only from Range
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
Problem: 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:
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Advanced modelling in finance using Excel and VBA
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- A Mathematician Plays the Stock Market
- PowerPoint® 2002 For Dummies®
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
No comments have been submitted.

