# subtotal

(redirected from subtotals)
Also found in: Dictionary, Thesaurus.

## subtotal

(sŏb′tōt″ĭl, sŏb-tōt′) [″ + L. totalis, entire]
Pert. to surgical procedures in which a portion of an organ, rather than the complete organ, is removed; partial, limited.
References in periodicals archive ?
After you use the Subtotals command, a new set of icons appears to the left of column A.
From the Data tab, choose Subtotals to open the Subtotals dialog box again.
Once your data are subtotaled and grouped in this manner, you can expand and collapse (show or hide) detailed line items by clicking the corresponding plus and minus signs in the left margin.
To check the formatting, click the #3 Group and Outline button and check that each of the subtotals is in bold text and have accounting underlines.
Click OK in the Subtotal dialog, and Excel will insert new subtotal rows in the data.
Exhibit 4, page 55, shows the Total Assets portion of exhibit 1, which was calculated by Subtotal. At first glance, you might conclude that Sum rather than Subtotal is the most efficient way to handle those numbers, since Subtotal requires a second parameter.
But even more important, note that the totals below the data table, which were created with the Subtotal function, automatically adjust to include only those visible cells in the calculation, so the displayed totals represent only the West region.
We began with the subtotals of the three data fields.
The problem really becomes noticeable when a multidimensional report has been created and someone wants to look at another dimension or get subtotals from another point of view.
Excel's Subtotal command inserts a new subtotal row every time the value in a certain column changes.
For successful subtotals, ensure that your data has no blank columns or blank rows.
Next, taking the various combinations of five cards in pairs and the player will receive two points each for a subtotal of another 12 points (for six pairs).

Site: Follow: Share:
Open / Close