SUBTOTAL function - Microsoft Support
WEBReturns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it …
Insert subtotals in a list of data in a worksheet - Microsoft Support
WEBInsert subtotals in a list of data in a worksheet. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013. You can automatically calculate subtotals and grand totals in a list for a column by using the Subtotal command. Important: Subtotals are …
Ways to count values in a worksheet - Microsoft Support
WEBUse the SUBTOTAL function to count the number of values in an Excel table or range of cells. If the table or range contains hidden cells, you can use SUBTOTAL to include or exclude those hidden cells, and this is the biggest difference between SUM and SUBTOTAL functions.
SUBTOTAL function - Microsoft Support
WEBReturns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it …
Subtotal and total fields in a PivotTable - Microsoft Support
WEBWhen working with a PivotTable, you can display or hide subtotals for individual column and row fields, display or hide column and row grand totals for the entire report, and calculate the subtotals and grand totals with or without filtered items.
Remove subtotals in a list of data in a worksheet - Microsoft …
WEBRemove calculated subtotal rows from a worksheet and remove subtotals from a PivotTable in Excel.
Outline (group) data in a worksheet - Microsoft Support
WEBUse the Subtotal command, which inserts the SUBTOTAL function immediately below or above each group of detail rows and automatically creates the outline for you. For more information about using the Subtotal function, see SUBTOTAL function .
Show or hide subtotals and totals in a PivotTable
WEBSum values in a PivotTable. Show or hide subtotals and grand totals in a PivotTable to add or remove them, and calculate them with or without filtered items.
Total the data in an Excel table - Microsoft Support
WEBThe Total Row default selections use the SUBTOTAL function, which allow you to include or ignore hidden table rows, however you can also use other functions.
Why can't I add subtotals in an Excel table? - Microsoft Support
WEBIf the Subtotal command is grayed out, that’s because subtotals can’t be added to tables. To add subtotals, convert your table to a range of data by right-clicking a cell in your table, pointing to Table, and then clicking Convert to Range.
Total the data in an Excel table - Microsoft Support
WEBYou'll see that Excel created the following formula: =SUBTOTAL (109, [Midwest]). This is a SUBTOTAL function for SUM, and it is also a Structured Reference formula, which is exclusive to Excel tables. Learn more about Using structured references with Excel tables.
Skip to content