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
Although this formula refers to other cells that contain a SUBTOTAL formula, those cells are ignored, to avoid
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.