After computing the subtotals for each group, insert the formula =SUBTOTAL(9,B2:B21) into a cell you need, then press Enter to get the grand total that removes the subtotals automatically.
When displaying a Total row in an Excel Table, the SUBTOTAL function is used. Excel automatically inserts the SUBTOTAL function, and you can change the behaviour by selecting from a drop-down option.
Select the Subtotal button from the Data tab of the Outline group.
A Subtotal dialogue box will popup, providing you options for how the subtotals should be shown.
The subtotals for each computer brand will appear in a new row very instantaneously.
Press the AutoSum button or the Alt+= keyboard shortcut. In the cell, the SUBTOTAL formula will be automatically added. Enter the code.
Learner's Ratings
4.7
Overall Rating
84%
9%
5%
2%
0%
Reviews
G
GM Salah Uddin
5
Thanks
M
MRIDHA MD MERAJ
5
Very good and Thank you so much
M
Md Mujahidul islam
5
This is a very good course.
M
Md Masud Rana
5
Good job
M
MD Yasin Khan
5
very helpfully for me thanke you learn vern team member
A
Abrar Hossen
5
I am happy for this course ....love you...I want to more course in bangla tutorial...from Bangladesh
Share a personalized message with your friends.