SUM

Sum two or more numbers.

Syntax

SUM(value1,

[value2]

)

value1

A number, cell, range, or JSON array to sum. For example: 7.

[optional] value2

Additional numbers, cells, or ranges, or JSON arrays to sum. For example: A3:A7.

SUM(A1:A5) returns 15, the sum of all the numbers in range A1:A5. Example 1