Beginner
Math
SUM
Adds all the numbers in a range of cells.
Compatibility: All Excel versions
Syntax
=SUM(number1, [number2], ...)
Example
=SUM(A1:A10)
When to Use It
Use SUM any time you need a total — a column of expenses, a list of scores, or a range of sales figures.