Microsoft Office Tutorials and References

In Depth Information

Figure 9-11:
Several types of summary functions are available for the Total row.

Using the drop-down list, you can select a summary function for the column. Excel inserts a formula that uses

the SUBTOTAL function and refers to the table's column using a special structured syntax (described later).

The first argument of the SUBTOTAL function determines the type of summary displayed. For example, if the

first argument is 109, the function displays the sum. You can override the formula inserted by Excel and enter

any formula you like in the Total row cell. For more information, see the sidebar “About the SUBTOTAL func-

tion.”

The SUBTOTAL function is one of two functions that ignore data hidden by filtering (the

other is the new AGGREGATE function). If you have other formulas that refer to data in

a filtered table, these formulas don't adjust to use only the visible cells. For example, if

you use the SUM function to add the values in column C and some rows are hidden be-