SUM Function. Sums numbers.(Microsoft Excel)

03/27/2024

Japanese version.

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)
NameOmissionExplanation
number1 to 255Required 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)))
Row direction
=BYCOL(A1:C3,LAMBDA(c,SUM(c)))
Column direction

---

Links

Microsoft Excel Functions Math & Trig

Examples of Use

Method of summing every other line.