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”

 

How to Sum Values in Excel 2010 - Sum values within a single cell


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

 

Cell in Excel

 

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:

 

Sum in Excel

 

And the result of this sum is:

 

Excel Cell

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:

 

Sum Values in Multiple Cells - Excel 2010

 

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

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

 

4 Ways to Sum Values in Excel 2010

 

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

 

4 ways to sum values in Excel 2010

 

(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)”

 

Sum function in Excel 2010

 

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

 

Sum results in Excel

 

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

 

Sum a range of cells in Excel 2010

 

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

 

Summing in Excel

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:

 

Auto Sum in Excel

 

Then, press the AutoSum button:

 

Sum values using the AutoSum function in Excel 2010

 

The result of your sum will appear in cell A4:

 

Add in Excel

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

 

Insert Function in Excel 2010

 

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

 

How to sum in Excel

 

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

 

Sum in Excel

 

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