In this chapter, we will look into aggregate functions, which are generally used to do the following:
Sum values
Count values
Average values
We will begin with functions that help do summations.
SUM Function
The SUM function is used to sum one or more numbers in a range of cells or literal values.
Syntax
=SUM(value1, [value2], ....)
The SUM function can take up to 255 arguments, as follows:
The first argument is mandatory. The remaining arguments are optional.
The arguments supplied to the SUM function can be a single cell reference, a cell range, or a literal numeric value.
Example
Figure ...
