SUM()
Adds up a range of numbers or a list of values.
SUM(number1, [number2], ...)SUM adds every number in the cells, ranges, or values you give it, ignoring text and blank cells. It's the most basic aggregation function in Excel.
For a sum with a condition, use SUMIF or SUMIFS instead of wrapping SUM in an IF.
Arguments
- number1
- A number, cell reference, or range to add.
- number2, ...optional
- Additional numbers, cells, or ranges to include.
Examples
=SUM(B2:B20)→48,210
Adds every value in the range.
=SUM(B2:B20, D2:D20)→91,455
Sums two separate ranges in one formula.