SUM Function

Adds a series of numbers.
Sample Usage
SUM(Cost1:Cost5)
Syntax
SUM(
  • number1
  • [
    • number2
      • ​
    • ...
    ]
)
  • number1
    —
    The number or range of numbers to add.
    • number2
      • ​
    • ...
    —[optional]
    Additional numbers or ranges of numbers to add.
Related Functions
SUMIF
SUMIFS
COUNT
COUNTIF
COUNTIFS
ANCESTORS
CHILDREN
PARENT
Was this article helpful?
YesNo