 Publishers of technology books, eBooks, and videos for creative people

• Print
This chapter is from the book

## sum some values

Although you can write a formula that adds multiple cell references, one cell at a time, it's much easier to use Excel's SUM function to add up the contents of a range of cells. Here are two ways to enter the SUM function in formulas to create subtotals for the values in column B.

Use the AutoSum button: Click the AutoSum button on the Standard toolbar.

Excel writes a formula that uses the SUM function to add a range of cells. A colored box appears around the cells included in the formula. If the formula is correct (as shown here), press Enter (Windows) or Return (Mac OS).

If the formula is not correct, enter the correct range reference and press Enter (Windows) or Return (Mac OS).

The result of the formula appears in cell B6.

Type and drag: Position the mouse pointer on cell B8. Press the mouse button and drag down to cell B26. All cells you dragged over are selected and referenced in the formula in cell B27. Press Enter (Windows) or Return (Mac OS). The result of the formula appears in cell B27.