Creating Subtotals Summary in Microsoft Excel 2010

In this article, we will learn how we can create subtotals summary in Microsoft Excel 2010.

Subtotal: - This option is used to calculate rows of related data quickly by inserting subtotals and totals.

This option is available in the Data tab under the outline group.
 

 
Let’s take an example to understand how we can create the subtotals summary.

We have data in range A1:E19 where column A contains region, column B contains city, column c contains product, column D contains Total revenue, and column E contains Net Revenue.
 

 
If we want to create subtotal according to the product, we need to follow below given steps:-

• Sort the field for which we want to have subtotal summary. In this Example, sort the list by product name.
• Go to Data tab.
• Click on sort under the Sort & Filter group.

• Sort dialog box will appear.
• Sort by product, Sort on Values and then select A to Z in order.

• Click on OK.

 

 
To insert the subtotal, follow below given steps:-

• Go to Data tab, and click on Subtotal in the Outline group.
• Subtotal dialog box will appear.

• Select product in the ‘At each change in’, and select Sum in the function, and then select Net Revenue in the Add subtotal. Now click on OK.

 

 
The subtotal summary will get created in Microsoft Excel.
 

 

 
To use the subtotal option, follow below given steps:-

• Go to data Tab, and select Subtotal from the Outline group.

• Subtotal dialog box will appear.
• Select year from the drop down list of ‘At each change in’.
• To add the fields, select Sum from the function drop down list.
• Check to Revenue, and click on OK.

• The data will get add as per the date field in Microsoft Excel.