SUM Function
Adds all the numbers in a column.
Syntax
SUM(<column>)
Parameters
Term |
Definition |
|---|---|
column |
The column that contains the numbers to sum. |
Return Value
A decimal number.
Remarks
If any rows contain non-numeric values, blanks are returned.
If you want to filter the values that you are summing, you can use the SUMX function and specify an expression to sum over.
Example
The following example adds all the numbers that are contained in the column, Amt, from the table, Sales.
=SUM(Sales[Amt])