Microsoft Office Tutorials and References
In Depth Information
Figure 9-27: Excel adds the subtotal formulas automatically and creates an outline.
The formulas all use the SUBTOTAL worksheet function. For example, the formula in cell E20 (Grand Total) is
as follows:
=SUBTOTAL(9,E2:E18)
Although this formula refers to other cells that contain a SUBTOTAL formula, those cells are ignored, to avoid
double-counting.
You can use the outline controls to adjust the level of detail shown. Figure 9-28, for example, shows only the
summary rows from the subtotaled table. These rows contain the SUBTOTAL formulas. I hid columns B and C
because they show only empty cells.
Search JabSto ::




Custom Search