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.
 
img1
 
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.
 
img2
 
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.

 
img3
 

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

 
img4
 

  • Click on OK.

 
img5
 
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.

 
img6
 

  • 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.

 
img7
 
The subtotal summary will get created in Microsoft Excel.
 
img8
 
img9
 
To use the subtotal option, follow below given steps:-

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

 
img10
 

  • 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.

 
img11
 

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

 
img12
 
 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube