paste_image14.jpg

 

You can type cell references directly into cells, or you can enter cell references by clicking cells, which avoids typing errors.

In the first lesson you saw how to use the SUM function to add all the values in a column. You could also use the SUM function to add just a few values in a column, by selecting the cell references to include.

Imagine that you want to know the combined acreage for parcels 12 and 13. You don't need to store the total, so you could enter the formula in an empty cell and delete it later. The example uses cell C6.

The example shows you how to enter the formula. You would click the cells you want to include in the formula instead of typing the cell references. A color marquee surrounds each cell as it is selected and disappears when you press ENTER to display the result 0.37. The formula =SUM (B3, B4) appears in the formula bar near the top of the worksheet whenever cell C6 is selected.

The arguments B3 and B4 tell the SUM function what values to calculate with. The parentheses are required to separate the arguments from the function. The comma, which is also required, separates the arguments.