Functions
SUM
Sum of arguments
Try it
When to use it
When should I use SUM instead of SUMIF?
Use SUM to total every value in a range; use SUMIF when you only want to total cells that meet a condition.
Can SUM add up numbers from several ranges at once?
Yes. Pass each range or value as a separate argument, e.g. SUM(range1, range2, 10), and SUM adds them all together.
Use cases
Add up a column of values from an inline array
Combine several subtotals into a grand total
Used in
Syntax
SUM(value1,...)