Microsoft Office Tutorials and References
In Depth Information
Figure 9-26: The Subtotal dialog box automatically inserts subtotal formulas into a sorted table.
When you click OK, Excel analyzes the database and inserts formulas as specified — it even creates an outline
for you. Figure 9-27 shows a worksheet after adding subtotals that summarize by month. You can, of course,
use the SUBTOTAL function in formulas that you create manually. Using the Data ⇒ Outline ⇒ Subtotals com-
mand is usually easier.