Excel FunctionsLesson 110Free preview
SUM
This lesson is part of Excel · All levels
Summary
SUM is an arithmetic function in Excel that sums the whole number in a given range or argument. The syntax is. This function is most commonly used to calculate the total data on a worksheet.
Key points
- Syntax: SUM(number1, [number2], ...)
- Cells containing text or blank are ignored in addition
- Can accept multiple ranges at once
- For conditional addition use SUMIF or SUMIFS
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.