# 4 Ways to Sum Values in Excel 2010

There are different ways to sum values in Excel. In this post, I will show you 4 ways to sum values in Excel 2010 using the following methods:

(1) Sum values within a single cell

(2) Sum values in multiple cells

(3) Sum values using AutoSum

(4) Sum values using the ‘Insert Function’

## Sum values within a Single Cell

To take a simple example, let’s suppose you wish to sum two numbers, within a single cell in Excel, in the following manner: 5+5

(1) First pick a cell. In our example we will use the cell A1.

(2) Double-click on the Cell A1.

(3) Type within the cell “=5+5”

(4) Finally, press Enter. The result of your sum will be 10:

This is a simple example, but the concept is the same even if you choose to sum multiple numbers within the same cell.

In this illustration, I chose to sum the following numbers: 5, 7, 50, 72, and 60:

And the result of this sum is:

## Sum Values in Multiple Cells

If you’d like to sum values that are located in multiple cells, there are few ways to accomplish this task.

To start, suppose you’d like to sum the numbers 25, 15 and 10. Originally, your numbers will look like this in Excel:

(1) Method#1 of summing numbers in multiple cells:

Initially, you’ll need to Double-click on cell A4. Then, type “=A1+A2+A3”

Finally, press Enter. You’ll get the following result of your Sum operation in cell A4:

(2) Method#2 of summing numbers in multiple cells:

Another way you can sum numbers that are located in multiple cells is by using the ‘SUM’ function:

First, you’ll need to Double-click on cell A4. Then, type “=SUM(A1+A2+A3)”

Finally, press Enter. The result of your sum will appear in cell A4. As before, the result of your sum will be 50:

(3) Method#3 of summing numbers in multiple cells:

A third way in which you can sum values in multiple cells is by using the ‘SUM’ function, while specifying the range of cells you’d like to perform the sum.

This function can be useful when you need to sum numbers across a large range of cells.

Here, you’ll need to double-click on cell A4, and then type “=SUM(A1:A3)”. This will sum all the values in the range of cells from A1 to A3:

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

## 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 that you’d like to sum.

In our example, select the range of cells A1 to A3 as below:

Then, press the AutoSum button:

The result of your sum will appear in cell A4:

## Sum values using the ‘Insert Function’

To sum your values using the ‘Insert Function’, you’ll need to follow the steps below:

(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

(5) 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:

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

In this post, we covered the ways in which you can Sum values in Excel.

However, Excel offers a variety of functions that you can apply to a data-set, such as the function to obtain the Max Value