SUM Function. Sums numbers.(Microsoft Excel)
The SUM function is a function to get the sum of numbers.
It is likely to be the first function that many people will come into contact with.
Contents
How it works
=SUM(number1 to 255)
| Name | Omission | Explanation |
|---|---|---|
| number1 to 255 | Required argument. The number to be summed. |
Demonstrate
In most cases, the argument specifies the range of cells to be summed.
If the specified cell range contains non-numeric values, such as alphabetic characters, they will be ignored and summed.
String numbers are also ignored.
However, if an error is included in the cell range, the SUM function will also result in an error.
Care must be taken when including the results of XLOOKUP functions in the calculation.
Spill
Spill when using the BYROW or BYCOL function.
=BYROW(A1:C3,LAMBDA(r,SUM(r)))
=BYCOL(A1:C3,LAMBDA(c,SUM(c)))
---