To Manually Enter a Formula in a Table Cell

1. Click inside a cell.
2. From the Table Cell contextual ribbon select Formula, then 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, click in the drawing outside the editor.

   The cell displays the result of the calculation.