Microsoft Office Tutorials and References
In Depth Information
Syntax:
Table 11.6. Function Arguments for
Table 11.6. Function Arguments for SUBTOTAL
SUBTOTAL
In Figure 11.18 , the customer summary rows were built with the SUBTOTAL
function, allowing the grand total row to be calculated with the simple for-
mula =SUBTOTAL(9,C2:C76). In contrast, after someone has built manual
subtotals using the SUM function, as shown previously in Figure 11.15 ,
the SUBTOTAL function doesn t work. You must replace SUM( with
SUBTOTAL(9, to convert the existing subtotal lines to the SUBTOTAL func-
tion.
Search JabSto ::




Custom Search