Insert a total for a range
You can insert a sum for a range of cells automatically by using AutoSum.
- In the design window, make sure the spreadsheet is activated. For instructions, see Help for your design program.
- Click the first blank cell that follows the data you want to sum, either below the column of data or to the right of the data in a row, or select a column range to sum.
- On the toolbar, click AutoSum
.
A suggested formula is displayed in the cell you selected or in the cell below the column range you selected.
- Do one of the following:
-
To accept the suggested formula, press ENTER.
-
To change the suggested formula, select the range you want to sum and press ENTER.
-