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.