O'Reilly logo

Picture Yourself Learning Microsoft® Excel® 2010 by Laurie Ulrich Fuller, Deidre Hayes, Jeffery A. Riley

Stay ahead with the world's most comprehensive technology and business learning platform.

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

Start Free Trial

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.

Start Free Trial

No credit card required