Subtotal | search
Click here to view Subtotal news from 60+ newspapers.
Bookmark or Share- Outline (group) data in a worksheet - Microsoft SupportIf you want, your grouped detail rows can have a corresponding summary row—a subtotal. To create these, do one of the following: Use the Subtotal command, which inserts the SUBTOTAL function immediately below or above each group of detail rows and automatically creates the outline for you.
- Insert subtotals in a list of data in a worksheet - Microsoft SupportYou 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 command will appear grayed out if you are working with an Excel table.
- Subtotal and total fields in a PivotTable - Microsoft SupportWhen 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. In a PivotTable, select an item of a row or column field. Make sure it is a field and not a value.
- Ways to count values in a worksheet - Microsoft SupportUse 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 SupportThis article describes the formula syntax and usage of the SUBTOTAL function in Microsoft Excel. Returns 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.
More
