Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

STEP-1: Sort the list on the field/s for which you want subtotals inserted using multi level sorting

Select the whole data including headers using ctrl+A ,click on Data  and select Sort.

Use “Add level” option to enable multi level sorting fields.

STEP-2: Click the Subtotal button in the Outline group on the Data tab. The Subtotal dialog box appears.

STEP-3: Select the field for which the subtotals are to be calculated in the “At Each Change In” drop-down list.

STEP-4: Specify the type of totals you want to insert in the “Use” Function drop-down list. Select the check boxes for the field(s) you want to total in the “Add Subtotal To” list box. Click OK.

When you use the Subtotals feature, you aren’t restricted to having the values in the designated field added together with the SUM function. You can instead use AVERAGE or COUNT function depending upon the requirement.

STEP-5: Repeat Step-2 to 4 again. This time In “AT each change in” field; select the next header for which you want the subtotals.

REMEMBER: Uncheck the “Replace current subtotals” check box. Otherwise previous subtotals would be replaced by this one.

Click Ok.

Excel adds the subtotals to the worksheet.

The bottom of a list showing the subtotals and a grand total.

Click Here to download- Excel Sample File


Published by

Category Students   Report

15 Likes   87 Shares   26400 Views


Popular Articles

Follow taxation Exam20 Book Book

CCI Articles

submit article

Stay updated with latest Articles!