Microsoft Office Tutorials and References
In Depth Information
Using Formulas in Tables
1.
Click any cell in the table.
2.
Place a check mark next to Table Tools
➪
Design
➪
Table Style Options
➪
Total Row.
3.
Click a cell in the Total Row and use the drop-down list to select the type of
summary formula to use (see Figure 15.11).
For example, to calculate the sum
of the Actual column, select
SUM
from the drop-down list in cell D15. Excel creates
this formula:
=SUBTOTAL(109,[Actual])
FIGURE 15.11
A drop-down list enables you to select a summary formula for a table column.
For the
SUBTOTAL
function,
109
is an enumerated argument that represents
SUM
. The
second argument for the
SUBTOTAL
function is the column name, in square brackets. Using
the column name within brackets creates “structured” references within a table (as
discussed further in the upcoming section, “Referencing data in a table”).
15
You can toggle the Total Row display via Table Tools ➪ Design ➪ Table Style Options ➪ Total Row. If you turn it off, the
summary options you selected will be displayed again when you turn it back on.
