Microsoft Office Tutorials and References

In Depth Information

**Examples of Math Functions**

The SUM function adds all the numbers in a range of cells. The arguments

number1,number2,...are one to 255 arguments for which you want the total

value or sum.

A typical use of this function is =SUM(B4:B12). It is also possible to use

=SUM(1,2,3). In the latter example, you cannot specify more than 255 individu-

al values. In the former example, you can specify up to 255 ranges, each of

which can include thousands or millions of cells.

In
Figure 11.1
,
cell B25 contains a formula to sum three individual cells:

=SUM(B17,B19,B23).