Microsoft Office Tutorials and References
In Depth Information
Using SUBTOTAL Instead of SUM with Multiple Levels of Totals
Many accountants can teach you the old accounting trick whereby you total
the entire column and divide by two to get the grand total. This is based on the
assumption that every dollar is in the column twice: once on the detail row
and once on the summary row. As shown in Figure 11.17 , this trick does work,
but it is hard to explain to your manager why it works.
Figure 11.17.
Figure 11.17. The old accounting trick of adding an entire column and dividing
The old accounting trick of adding an entire column and dividing
by two works but is hard to explain.
by two works but is hard to explain.
Tip
The best way to insert the SUBTOTAL function is to use the Subtotals
icon on the Data tab. However, you can set up these functions manu-
ally.
The solution is to use the SUBTOTAL function. This powerful function has
been around since Excel 97.
See
See Chapter22 , UsingAutomaticSubtotals , formoreinform-
ation about working with subtotals.
Search JabSto ::




Custom Search