- name the sheet
- understand references
- enter information
- activate a cell
- enter row headings
- enter column headings
- make a column wider
- enter values
- calculate a difference
- calculate a percent diff
- sum some values
- calculate net income
- copy formulas
- copy and paste
- use the fill handle
- change a value
- extra bits
This chapter is from the book
This chapter is from the book
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:
)
Activate cell B6.
)
)
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:
Activate cell B27.
)
Type =SUM(.
)
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.
)
)
Type ).
)
)
Press Enter (Windows) or Return (Mac OS). The result of the formula appears in cell B27.
)