How to Use ADD in Google Sheets in 2020?

ADDReturns the sum of two numbers. Equivalent to the `+` operator.

Sample Usage

ADD(A2,A3)

ADD(3,4)

Syntax

ADD(value1, value2)

value1 – The first addend.

value2 – The second addend.

Notes

Unlike SUM, ADD only supports the addition of two scalar values and takes neither ranges nor more than two arguments.

See Also

SUM: Returns the sum of a series of numbers and/or cells.

QUOTIENT: Returns one number divided by another, without the remainder.

PRODUCT: Returns the result of multiplying a series of numbers together.

MULTIPLY: Returns the product of two numbers. Equivalent to the `*` operator.

MINUS: Returns the difference of two numbers. Equivalent to the `-` operator.

DIVIDE: Returns one number divided by another. Equivalent to the `/` operator.

Examples