O'Reilly logo

Microsoft Excel X for Mac OS X: Visual QuickStart Guide by Maria Langer

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

Math & Trig Functions

Excel's math and trig functions perform standard mathematical and trigonometric calculations. On the next few pages, I tell you about the most commonly used ones, starting with one so popular it even has its own toolbar button: SUM.

The SUM function

The SUM function (Figure 5) adds up numbers. It uses the following syntax:

SUM(number1,number2,…)

Although the SUM function can accept up to 30 arguments separated by commas, only one is required.

To use the AutoSum button

1.
Select the cell below the column or to the right of the row of numbers you want to add.
2.
Click the AutoSum button on the Standard toolbar once. Excel examines ...

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