Insert subtotals in a list of data in a worksheet - Microsoft Support
How to use the Subtotal command in Excel to calculate subtotals and grand totals in a list.
SUBTOTAL function - Microsoft Support
How to use the SUBTOTAL function in Excel to return a subtotal in a list or database.
Remove subtotals in a list of data in a worksheet
Remove calculated subtotal rows from a worksheet and remove subtotals from a PivotTable in Excel.
Subtotal and total fields in a PivotTable - Microsoft Support
When 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 …
Show or hide subtotals and totals 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.
Why can't I add subtotals in an Excel table? - Microsoft Support
Click one of the cells containing your data. Click Data > Subtotals. In the Subtotals box, click OK. Tips: Once you’ve added your subtotals, an outline graphic appears to the left of your data. You can click …
Remove subtotals from a PivotTable - Microsoft Support
In a PivotTable, subtotals are calculated automatically and appear by default. Here’s how to hide them: Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon. Click Design > …
Ways to count values in a worksheet - Microsoft Support
Use 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 …
Sort data in a PivotTable or PivotChart - Microsoft Support
You can sort on individual values or on subtotals by right-clicking a cell, choosing Sort, and then choosing a sort method. The sort order applies to all the cells at the same level in the column that …
Overview of PivotTables and PivotCharts - Microsoft Support
Subtotaling and aggregating numeric data, summarizing data by categories and subcategories, and creating custom calculations and formulas. Expanding and collapsing levels of data to focus your …
Create a waterfall chart - Microsoft Support
Use the waterfall chart to quickly see positive and negative values impacting a subtotal or total value. Waterfall charts are often used to visualize financial statements, and are sometimes called bridge …