» 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:
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Windows XP Pocket Reference
- Keys to Reading an Annual Report (Barron's Business Keys)
- Accounting and Financial Fundamentals for Nonfinancial Executives
- Guide to Financial Reporting and Analysis
No comments have been submitted.
