Home>Blogs>Excel Tips and Tricks>Subtotal feature in Excel
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:

Meet PK, the founder of PK-AnExcelExpert.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your Excel skills to the next level!