You are here: All Help Topics > Advanced Features > Calculations > To add a range of cells using the summation button

Adding a Range of Cells Using the Summation Button

The Summation button will copy a formula that calculates the sum of the selected numeric cells to the clipboard.

For alphanumeric cells, clicking the Summation button will concatenate the text of the selected cells.

  1. Select the cells by dragging the mouse over the selected area or dragging while holding Alt.
  2. On the Document tab, click Summation.

  3. Position the insertion point in the total cell.
  4. On the Home tab, click Paste.

    The Equation bar displays the addition of all cells in the selection.

Note: Only Numeric cells can be summed. Alphanumeric cells will have their text concatenated.

Related Topics