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
82%
10%
4%
3%
1%
Reviews
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
S
sadananda basak
5
Teaching technique is easy to understand. Thanks.
J
Joydeep
5
nice
U
Uttam Nandi
5
Very nice teaching.
R
RABIN DEY
5
REALLY HELPFUL COURSE
S
Subhasis Bosu
5
good
A
Anamul Huq
5
This is helpful how are zero to intermediate level.
S
Souvik Dutta
4
very good course
R
Raj
5
zero to hero course excel
K
KAUSHIK PAUL
5
outstanding class, mind-blowing practical class and concept. I just love it and thank you very so much.
again Thank you sir and Thank you Madam.
Share a personalized message with your friends.