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.
How it works
=SUM(number1 to 255)
|number1 to 255||Required argument. |
The number to be summed.
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.