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?
Follow below steps:-
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.
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 info@exceltip.com
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.
it says you've entered too many arguments for this function. i am working on around 1280 cells
this is not working for large numbers of cells