Subtotal in Excel
Excel Tips and Tricks

Subtotal feature in Excel

In this article, you will learn about the Subtotal feature of Microsoft Excel. Excel can organize data in groups, allowing you to easily show and hide different sections of your worksheet. You can also summarize different groups using the Subtotal command and create an outline for your worksheet.

To use the Subtotal feature, make sure your data is properly sorted. Here we have taken the example of Student wise marks as given in below image.

Student wise Marks
Student wise Marks

Our data is sorted by student Name. To apply the Subtotal feature below are the steps-

  • Select the data.
  • Go to Data tab>>Subtotal

Below given subtotal window will be opened-

  • Select the Student name in first drop down
  • Select Sum as use function
  • Check the Marks and Max Marks
  • Click on OK

Sub Total will be added. You can add background color for totals.

Table with Subtotal
Table with Subtotal

Click here to download practice file-

Watch the step by step video tutorial:

My Name is PK. I am founder of I am a Microsoft Certified Professional. I have more than 12 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.