2011

Table Of Contents
Numbers will fill automatically by increments of 1 if one cell is selected and
dragged. Similarly, dates will resolve by increments of one day if only one cell
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 1352
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.
Use Formulas in Table Cells | 1413