Nóta
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as shíniú isteach nó eolairí a athrú.
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as eolairí a athrú.
Applies to:
Calculated column
Calculated table
Measure
Visual calculation
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 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])