4 Ways to Sum Values in Excel (with examples)

There are different ways to sum values in Excel. In this short guide, I’ll show you 4 ways to sum values:

  • Within a single cell
  • Across multiple cells
  • Using AutoSum
  • Using the Insert Function

Sum Values within a Single Cell

To start with a simple example, let’s suppose that you’d like to sum two numbers within a single cell in Excel: 5 + 5

To get the sum:

(1) Choose a cell in Excel. In our example, let’s pick cell A1

(2) Double-click on cell A1

(3) Type within the cell =5+5

Add values in a cell

Finally, press Enter, and you’ll get the sum of 10:

Result

What if you want to sum multiple numbers within a single cell?

For example, let’s say that you want to sum these numbers: 5, 7, 50, 72, and 60.

You can then double click on cell A1, and then copy/type the following:

=5+7+50+72+60

This is how the function would look like in Excel:

4 Ways to Sum Values in Excel

Press Enter, and you’ll get the total sum of 194:

Total result

Sum Values across Multiple Cells

There are few ways to sum values across multiple cells. Here, I’ll review 3 methods to sum the numbers of 25, 15 and 10 that are located in different cells as below:

Data

Method 1: Adding each cell individually

To begin, double-click on cell A4, and then type/copy:

=A1+A2+A3

In Excel:

4 Ways to Sum Values in Excel

Finally, press Enter. You’ll get the result of 50 in cell A4:

Sum Values in Excel

Method 2: Using the SUM function

To use the SUM function, double-click on cell A4. Then, type/copy:

=SUM(A1+A2+A3)

The SUM function in Excel would look like this:

4 Ways to Sum Values in Excel

Press Enter, and you’ll get the same sum of 50:

Add values

Method 3: Summing a range of cells

What if you need to sum a large number of cells?

Typing each individual cell would be a tedious task.

Instead, you can specify the range of cells that you’d like to apply the sum function.

Here, you’ll need to double-click on cell A4, and then type/copy:

=SUM(A1:A3)

This will sum all the values in the range of cells from A1 to A3:

Add values across range of cells

Press Enter, and you’ll get the same result of 50:

Addition result

Sum Values using AutoSum

In order to sum the numbers 25, 15 and 10 using the AutoSum function, you’ll need to select the range of cells A1 to A3. Then, press on the AutoSum button:

4 Ways to Sum Values in Excel

The result of your sum will appear in cell A4:

Sum Values in Excel

Sum Values using the Insert Function

To sum your values using the Insert Function:

(1) Select the cell where you’d like to populate the result of your sum. In our example, it will be cell A4

(2) Press the fx button

(3) Select ‘SUM’

(4) Press OK

Sum Values in Excel

You’ll now need to select the range of cells that you’d like to sum. In our case, the range of cells is A1 to A3:

How to Sum Values in Excel

Finally, press OK. The result of your sum will be displayed in cell A4:

Add values

You just saw how to sum values in Excel using a variety of methods. You may also wish to explore the following guides that explain how to get the max value, or perform basic arithmetic operations in Excel.