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.6
Overall Rating
81%
11%
5%
3%
0%
Reviews
S
Srijib Bhadra
5
MS Excel is a very important course, and it has helped me a lot in many ways
S
Sakibul Hasan Akash
5
"The teacher's presentation was very clear and well-organized. He tried to explain everything one by one. The teacher explained the topic very well and presented all the important points in a simple
S
Sayeed Arshif
5
Best
S
SUSANTA BARMAN
4
best website...thanks for this, but, If there was a system to share Excel files along with the video, it would be convenient to practice while watching the video
P
Prabhat Yadav
5
Superb and amazing 😍🤩 enjoyable experience.
P
pritam chakraborty
5
very good
S
Sudip Sadhukhan
5
Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you
Share a personalized message with your friends.