## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

### Creating a Total with the SUM Function

AS YOU MIGHT GATHER from the examples so far, SUM is by far the most popular function. In fact, you will most likely use the SUM function in just about every workbook you create.

The SUM function is used to total the values in a range of cells. In fact, you can enter as many ranges as you want as arguments to the SUM function, as long as you remember to separate those arguments with commas. For example, take a look at the payroll worksheet shown in Figure 3-2. In order to calculate the net pay, you must take an employee’s gross pay, minus a bunch of deductions. The first set of deductions is for taxes, which for the first employee are found in the range I8:K8. Next comes the medical deduction in cell M8, ...

## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

No credit card required