Select any cell in the table, hold down Alt, press A and B once(or select the 'Data' tab, click 'Subtotal' in the top right of the screen), open the 'Subtotal' dialog, select 'Dept' for 'At each change in', select 'Sum' for 'Use function', check the 'Payable Salary' for 'Add subtotal to', and other keep the default settings, click 'OK' to subtotal the ''Payable Salary'' of each department Operation process steps, see screenshot in Figure 4: Click the column number B, select the column B, select the 'Data' tab, click the 'A → Z' icon, open the 'Sort Warning' dialog box, select 'Extend the selection', click 'Sort', then column B is sorted in ascending order, and the same departments are connected together, so that it is convenient to subtotal the same department the operation process steps are as shown in Figure 3:Ģ. If you want to subtotal by department, calculate the 'Payable Salary' for each department. (I) How to insert subtotals in excel by one field Right-click one of the cells in the table, select 'Table → Convert To Range' in the pop-up menu, pop-up a dialog box that asks 'Do you want to convert the table to normal range', click 'Yes', then the table will be converted to range, sort, filter And subtotal are available the process steps are shown in Figure 2:

Click the column number H, select the column H, select the 'Data' tab, the Sort, Filter and subtotal are grayed out select the range in which there are data, the Sort and Filter are available, but the subtotal is still not available the demo is shown in Figure 1:Ģ. Why are the sort, filter and subtotal grayed out in excel?(Excel subtotal not available)ġ. Sometimes you may encounter that sort and subtotal are grayed out when subtotal, what is the reason? Let's start with the discussion of subtotals from this issue. The operations with function of subtotal in Excel are divided into the subtotal for the fields to be selected, the results of subtotal are copied, sorted and deleted. This article will first introduce the subtotal by the function of subtotal, and the other two subtotal methods are introduced in the next article. The formula is flexible and can subtotal according to various criteria, and the results of subtotal can be extracted, but the formula is complicated. It is powerful, simple to subtotal, and can be aggregated to meet various requirements. You must create a PivotTable before subtotaling, if you subtotal with PivotTable. It can complete the subtotal of one field, two fields or more than two fields, but sort before subtotaling, and it is not flexible and cannot complete complicated subtotal.

You can subtotal in the original tabl with the function of subtotal. You can subtotal with the function of subtotal, PivotTable, and formula in Excel.

How to add multiple subtotals in excel