Adding Groups of Numbers

To add a group of adjacent numbers (in the same column or row):

  1. Select the groups of cells that you want to add. (To select a group of cells, click on the first cell of the group, hold down your mouse button, and drag the cursor over the other cells you want to select). When selecting:

  2. Go to the Data menu, and click Add Selected Numbers. Or, if you are in Easy Mode, click the Add Selected Numbers button (in Advanced Mode, click the icon with a blue sigma symbol).

Note: This will not work if the cell in which the total should appear is occupied, or if a block of cells has been selected (i.e., more than one row and more than one column).

  1. The values in the selected cells will be added together. If you selected a group of numbers in a column, this sum will appear in the cell immediately below the your selection. If you selected a group of numbers in a row, this sum will appear in the cell immediately to the right of your selection.

Note: A formula (rather than an actual number) including the SUM function will be inserted into the cell. This formula represents the sum of the cells you selected. This sum is a value, and thus, can be used in calculations. It will also be included in row and column totals.

 

Notes on Subtotals

Subtotalling numbers in a column is different from adding a selected group of cells.

When subtotalling numbers (by clicking Subtotal Above Numbers):

See Subtotaling Numbers for further details.