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
Finally, press Enter, and you’ll get the sum of 10:
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:
This is how the function would look like in Excel:
Press Enter, and you’ll get the total sum of 194:
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:
Method 1: Adding each cell individually
To begin, double-click on cell A4, and then type/copy:
Finally, press Enter. You’ll get the result of 50 in cell A4:
Method 2: Using the SUM function
To use the SUM function, double-click on cell A4. Then, type/copy:
The SUM function in Excel would look like this:
Press Enter, and you’ll get the same sum of 50:
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:
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 A1 to A3. Then, press on 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:
(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
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:
Finally, press OK. The result of your sum will be displayed in cell A4:
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.