How to Use the SUM Formula in Excel: Easy Guide

The SUM formula is the easiest way to add numbers together in Excel. You can use it to add single cells, a line of cells, or multiple groups of numbers.

Formula Syntax

Here is how you write the formula:

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

• number1: The first number or range of cells you want to add (Required).
• number2, ...: Other numbers or cell ranges you want to add (Optional).

You can also write it simply with a range:

=SUM(start_cell:end_cell)

3 Simple Ways to Use SUM

1. Add a List of Cells (Range)

To add a whole column or row of numbers (like A1 to A10):

=SUM(A1:A10)

2. Add Separate Cells or Groups

To add cells from different places, separate them with commas:

=SUM(A1:A10, C1:C10, E5)

This adds everything in A1:A10, everything in C1:C10, and cell E5.

3. Video Tutorial in khmer

4. Quick AutoSum Shortcut ⚡

You do not have to type the formula manually. Click an empty cell below your numbers and press:

• Windows: Alt + =
• Mac: Cmd + Shift + T (or Option + Cmd + =)

Excel will automatically write =SUM(...) for you. Press Enter to get the total!

Handy Tips

Add an Entire Column

If you keep adding new rows, you can sum the whole column:

=SUM(A:A)

Note: Put this formula in a different column (like B1) so Excel does not get confused.

Do Math with the Result

You can multiply or calculate percentages directly on your total:

=SUM(A1:A10) * 0.10

(This calculates 10% of the total sum).

Fixing Common Problems