To Add a Formula to Table Cells

1. Click inside a cell.
2. On the Table Cell visor, click one of the following:
   • Insert Formula > Sum
   • Insert Formula > Average
   • 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, press Esc until no cells are selected.

Manually Enter a Formula in a Table Cell

1. Click inside a cell.
2. From the Table Cell visor, select Insert Formula > Equation
3. 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 ().

4. To save your changes and exit the editor, press Esc until no cells are selected.

   The cell displays the result of the calculation.