Use Formulas in Table Cells
Expand All
Expand all collapsed sections.
Collapse All
Collapse all expanded sections.
ConceptProcedureQuick Reference
 
 
 

To sum the values in a range of 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 Insert Formula Sum.

    The following prompt is displayed:

    Select first corner of table cell range:

  3. Click inside the first cell in the range.

    The following prompt is displayed:

    Select second corner of table cell range:

  4. Click inside the last cell in the range.

    The In-Place Text Editor opens and displays the formula in the cell.

  5. Edit the formula, if necessary.
  6. To save your changes and exit the editor, use one of the following methods:

    The cell displays the sum of the values in the range of cells. Empty cells and cells that do not resolve to a numeric value are ignored.

 Shortcut menu: Select and right-click a cell or range of cells. Click InsertFormulaSum.