SUBTOTAL function - Microsoft Support
How to use the SUBTOTAL function in Excel to return a subtotal in a list or database.
Insert subtotals in a list of data in a worksheet - Microsoft Support
You can automatically calculate subtotals and grand totals in a list for a column by using the Subtotal command. Important: Subtotals are not supported in Excel tables. The Subtotal …
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. …
Total the data in an Excel table - Microsoft Support
You'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 …
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 …
Excel functions (by category) - Microsoft Support
Lists all Excel functions by their category, such as Logical functions or Text functions.
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 …
SUBTOTAL function - Microsoft Support
How to use the SUBTOTAL function in Excel to return a subtotal in a list or database.
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.
Total the data in an Excel table - Microsoft Support
You'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 …