Microsoft Office Tutorials and References
In Depth Information
Using SUBTOTAL Instead of SUM with Multiple Levels of Totals
SUM function to total each customer. Cells C5, C10, C15, and so on contain a
SUM function.
Figure 11.15.
Figure 11.15. Whoever manually summed these rows doesn t know about the
Whoever manually summed these rows doesn t know about the
Subtotal command on the Data tab.
Subtotal command on the Data tab.
It would be very difficult to enter a grand total at the bottom of this data
set. You might have to enter a long formula that points only at the summary
rows. In this particular case, the formula to provide a grand total for 15
customers would be possible, as shown in Figure 11.16 . If you had 500 cus-
tomers, however, the formula would be nearly impossible to enter.
Figure 11.16.
Figure 11.16. It is difficult to enter the grand total formula.
It is difficult to enter the grand total formula.
Search JabSto ::




Custom Search