2012

is selected. If two cells are manually filled with dates one week apart, the
remaining cells are incremented by one week.
See also:
■ Use Fields in Text on page 994
To add a formula to table cells
1 Select the table cell where you want to place the formula by clicking
inside it. The Table toolbar is displayed.
2 On the Table toolbar, click one of the following:
■ Insert Formula ➤ Average
■ Insert Formula ➤ Sum
■ Insert Formula ➤ Count
■ Insert Formula ➤ Cell
3 Follow the prompts.
4 Edit the formula, if necessary.
5 To save your changes and exit the editor, click in the drawing outside
the editor.
To manually enter a formula in a table cell
1 Double-click inside a table cell.
The In-place Text Editor opens.
2 Enter a formula (a function or an arithmetic expression), as in the
following examples:
■ =sum(a1:a25,b1). Sums the values in the first 25 rows of column A
and the first row in column B.
■ =average(a100:d100). Calculates the average of the values in the first
4 columns in row 100.
■ =count(a1:m500). Displays the total number of cells in column A
through column M in rows 1 through 100.
■ =(a6+d6)/e1. Adds the values in A6 and D6 and divides the total by
the value in E1.
Use Formulas in Table Cells | 1053