How to Use SUM in Excel: Simple Guide with Examples

Use the SUM function in Excel to add numbers or ranges of cells. Enter =SUM(number1, number2, ...) or =SUM(range) in a cell to get the total of those values.

Syntax

The SUM function adds numbers or ranges of cells. It can take individual numbers, cell references, or ranges separated by commas.

• number1, number2, ...: Numbers or cell references to add.
• range: A continuous group of cells to add.

excel

=SUM(number1, [number2], ...)
=SUM(range)

Example

This example shows how to add numbers in cells A1 to A5 using the SUM function.

excel

A1: 10
A2: 20
A3: 30
A4: 40
A5: 50

In cell A6, enter:
=SUM(A1:A5)

Output

150

Common Pitfalls

Common mistakes include:

• Forgetting the equal sign = before SUM.
• Using incorrect range syntax like A1-A5 instead of A1:A5.
• Including text or empty cells that do not affect the sum but may confuse beginners.

excel

Wrong: =SUM(A1-A5)
Right: =SUM(A1:A5)

Quick Reference

Usage	Description
=SUM(10, 20, 30)	Adds the numbers 10, 20, and 30 to get 60
=SUM(A1, A2, A3)	Adds values in cells A1, A2, and A3
=SUM(A1:A5)	Adds all values from cell A1 through A5
=SUM(A1:A5, C1:C3)	Adds values from two ranges A1 to A5 and C1 to C3

Key Takeaways

Always start the formula with an equal sign = before SUM.

Use a colon : to specify a range of cells, like A1:A5.

You can add individual numbers, cell references, or ranges together in one SUM function.

Avoid using incorrect symbols like a dash - instead of a colon for ranges.

Empty cells or text in the range do not affect the sum but check your data to avoid confusion.