The SUM function is the single most important function to know in Excel. SUM adds all the numbers that you specify as arguments.

Each argument can be a range, a cell reference, an array, a constant, a formula, or the result from another function. For example, SUM(B3:B9) adds all the numbers that are contained in cells B3 through B9.

The cells or ranges you are summing do not have to be adjacent to one another. For another example, SUM(B3, C7, H25) adds the numbers that are contained in cells B3, C7, and H25.

SUM takes 1 required argument and 29 optional arguments:

Syntax: SUM(number1, [number2], ... )

#1)
Using the SUM function:
#2)
The arguments for the SUM function are:
Argument Required? Description
number1, number2, ... Required 1 to 30 arguments for which you want the total value or sum.
#3)
A couple things:
If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, or text in the array or reference are ignored.
If any arguments are error values, or if any arguments are text that cannot be translated into numbers, Excel displays an error.

Summary

The SUM function is the single most important function to know in Excel. SUM adds all the numbers that you specify as arguments.
comments powered by Disqus