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