Returns the sum of a series of numbers and/or cells.
SUM(value1, [value2, ...])
value1- The first number or range to add together.
value2, ...- [ OPTIONAL ] - Additional numbers or ranges to add to
If only a single number for
SUMis specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function.
SUMSQ: Returns the sum of the squares of a series of numbers and/or cells.
SUMIF: Returns a conditional sum across a range.
SERIESSUM: Given parameters
a, returns the power series sum a1xn + a2x(n+m) + ... + aix(n+(i-1)m), where i is the number of entries in range `a`.
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.
ADD: Returns the sum of two numbers. Equivalent to the `+` operator.
Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.