Automatic subtotal in MS Excel

134 views · Published 6 August 2017 · 6:07 · Indexed 11 October 2026

Channel: Krishna S · 2017 · Science & Technology

Watch on YouTube

Have you ever wanted to summarize the Excel data in different levels? Say Grand Total, Sub Total and then again Sub-Sub-Total? 

This video will help you to understand how to get the sub total summary in different levels. 

Excel has built in Sub Total function. Using which we can create a multi level summary of sub totals. 

When you are performing the second level of subtotal, make sure that you are not deleting the first level subtotal.



Subscribe to my channel:
http://www.youtube.com/user/krishnayess?sub_confirmation=1
YouTube Channel: https://www.youtube.com/krishnayess
My Blog: http://krishnasr.blogspot.in/
Google Plus: https://plus.google.com/+KrishSanj/
Twitter @iTwittt
https://twitter.com/iTwittt

More from this channel

• 5:15 How to get a list of files in folder in Excel

  Krishna S

  3,143 views · 30 June 2015

• 7:04 How to delete blank rows in Excel

  Krishna S

  3,455 views · 3 July 2015

• 7:38 How to create macro in Personal workbook

  Krishna S

  342 views · 16 August 2015

• 5:43 Copy of How to create your own Excel Add-in - Currency converter - number to text

  Krishna S

  113 views · 13 October 2015

• 3:03 How to format MS Excel cell comments

  Krishna S

  142 views · 20 November 2015

• 3:01 Spellnumber in MS Word Part 2

  Krishna S

  4,514 views · 20 November 2015

• 3:01 Spellnumber in MS Word Part 3

  Krishna S

  2,645 views · 20 November 2015

• 7:25 Excel cell referencing RELATIVE ABSOLUTE and MIXED

  Krishna S

  1,068 views · 14 January 2016