Add up a range of numbers.
Syntax
SUM(number1, [number2], …)Arguments
number1required
The first number, cell, or range to add.
number2…optional
Additional numbers or ranges.
SUM totals the numbers in one or more ranges or individual cells — the most-used function in Excel. It ignores text and blanks, so a stray label in a column won't break the total.
=SUM(B2:B100)→$248,500Adds every number in the range.
=SUM(B2:B10, D2:D10)→1,420Totals two separate ranges at once.
Select the range
Highlight the cells you want to total.
Add more ranges if needed
Separate additional ranges with commas.
The numbers are likely stored as text. Convert them with VALUE or by multiplying by 1, and SUM will pick them up.