Summing Subtotals Only from Range

In this article, we are going to learn how to calculate the sum of the subtotal values only in Microsoft Excel.

Subtotal function is used to return a subtotal in a list or database.



Let’s take an example and understand:-

We have revenue data month, year and date wise. Also, we have subtotal for every year. Column B contains six groups of numbers (cells B2, cells B4:8, B10:B12, B14:B15, B17:B21, B23.
Cells B3, B9, B13, B16, B22, and B24 contain SUBTOTAL formulas, which total the numbers to each group.

How can we find the sum of the subtotals values only?


image 1


Follow below steps:-

  • Enter the formula in cell E25.
  • =SUBTOTAL(9,E2:E24)
  • Press Enter on keyboard.
  • Only subtotal number will be calculated.


image 2


Formula Explanation: -In this formula, subtotal function will help to return the calculation of subtotal numbers.In this formula in subtotal formula, we have used 9 to calculate the sum of subtotal and then select the reference range of subtotal.

This is the way we can use subtotalfunction in Microsoft Excel for different calculations for the subtotal.


image 48


If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at


Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.