{"id":18859,"date":"2013-05-08T16:15:48","date_gmt":"2013-05-08T10:45:48","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=18859"},"modified":"2024-04-12T14:24:24","modified_gmt":"2024-04-12T08:54:24","slug":"use-subtotals","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/use-subtotals\/","title":{"rendered":"Use Subtotals"},"content":{"rendered":"

Use Subtotals<\/strong><\/h4>\n

a worksheet with sales data for three different product categories, you can first sort the products by category, and then select all the cells that contain data and open the\u00a0Subtotal\u00a0dialog box (Data\u00a0menu,\u00a0Subtotals\u00a0command).<\/p>\n

\"1\"<\/a><\/p>\n

In the\u00a0Subtotal\u00a0dialog box, you can choose the column on which to base your subtotals (such as every change of value in the Week column), the summary calculation that you want to perform, and the column or columns with values to be summarized. For example (as shown in the previous picture), you could calculate subtotals for the number of units sold in each category. After you define your subtotals, they appear in your worksheet.<\/p>\n

\"2\"<\/a><\/p>\n

As the previous picture shows, when you add subtotals to a worksheet, Excel also defines groups based on the rows used to calculate the subtotals. The groupings form an outline of your worksheet based on the criteria that you used to create the subtotals.<\/p>\n

\"3\"<\/a><\/p>\n

There are three types of controls in the outline section:<\/strong><\/p>\n