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.
- Select the cells by dragging the mouse over the selected area or dragging while holding Alt.
-
On the Document tab, click Summation.
- Position the insertion point in the total cell.
-
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.