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

Home > Articles

  • Print
  • + Share This
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:

one.jpg Activate cell B6.

two.jpg 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.

three.jpg 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:

one.jpg Activate cell B27.

two.jpg Type =SUM(.

three.jpg Position the mouse pointer on cell B8.

four.jpg 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.

five.jpg Type ).

six.jpg Press Enter (Windows) or Return (Mac OS). The result of the formula appears in cell B27.

  • + Share This
  • 🔖 Save To Your Account