Subtotal Command

Do you struggle to compile a report of Total Sales per Product? If your answer is yes, then the Subtotal Command can be the solution to your problem. The Subtotal Command automatically applies grouping and subtotals into a data list, using the specified summary function. Follow the steps below as we explain how that can be done.

Applies To: Excel 2003, 2007, 2010

  1. Using the screen shot below we are going to create a Total Sales Per Product Report

2.  Sort the list in ascending order by Product Name column

3.  Select as below

4.      Then as below

5.      The Total Sales per Product report will be generated as below

N.B. The list should be sorted by the Product Name column.

Click 1 to display the Grand Total, 2 to display the Product Totals,3 to display the entire report.



If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email [email protected] and yours could be the next Tip of the Week.

Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations