Use Formulas in Table Cells

Use Formulas in Table Cells

Use Formulas in Table Cells

 

Annotate Drawings > Tables > 

Use Formulas in Table Cells

Expand All Expand all collapsed sections. Collapse All Collapse all expanded sections.

Concept

Procedure

Quick 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:
   • Click OK on the toolbar.
   • Click in the drawing outside the editor.
   • Press CTRL+ENTER.

   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.