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).
Search JabSto ::




Custom Search