- Click inside a cell.
- On the Table Cell visor, click one of the following:
- Insert Formula
> Sum
- Insert Formula
> Average
- Insert Formula
> Count
- Insert Formula
> Cell
- Insert Formula
- Follow the prompts.
- Edit the formula, if necessary.
- To save your changes and exit the editor, press Esc until no cells are selected.
Manually Enter a Formula in a Table Cell
- Click inside a cell.
- From the Table Cell visor, select
Insert Formula
> Equation
- 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 a colon to define a range of cells and a comma for individual cells. A formula must start with an equal sign (=) and can contain any of the following signs: plus (+), minus (-), times (*), divided by (/), exponent (^), and parentheses ().
- To save your changes and exit the editor, press Esc until no cells are selected.
The cell displays the result of the calculation.