# Using the SUM Function in Excel

Coming up next: Using the MIN and MAX Functions in Excel

### You're on a roll. Keep up the good work!

Replay
Your next lesson will play in 10 seconds
• 0:01 The SUM Function
• 2:45 Using SUM to Subtract
• 3:43 Performing More Than…
• 5:07 Other Examples
• 5:58 Lesson Summary
Save Save

Want to watch this again later?

Timeline
Autoplay
Autoplay
Speed

#### Recommended Lessons and Courses for You

Lesson Transcript
Instructor: Karen Sorensen

Karen has a Bachelors in Communications. She has 25 years of experience in Information Systems, Adult Learning and Virtual Training.

When you need to perform calculations to add, subtract, divide and multiply, the SUM function is perfect for helping to carry out those tasks. This lesson will introduce you to the SUM function and explain how to use SUM in your formulas.

## The SUM Function

Functions are used to perform mathematical calculations in Excel. There are many different types of functions, depending on the calculation you need to perform; however the most common type is the SUM function. SUM is normally used to add a range of cells together. However, you can also use the SUM function to subtract, multiply and divide.

This lesson will introduce you to the SUM function in Excel and explain how to use it in a formula. We will also take a look at different example formulas where the SUM function is used.

The best way to learn about the SUM function is to start with an example Excel worksheet. Imagine you put together a budget for college expenses. You have numbers for three semesters, and the worksheet is grouped into expenses and income.

You have entered the expenses for the fall semester into column B, specifically B3 through B7. You want to put the total expenses in B15. Now, there are a few ways to enter a formula, but let's look at the steps I consider to be the easiest:

1. Select the cell where you want to add your formula (in our example, this is B15).
2. Type =SUM(B3:B7). Notice how Excel highlights the range of cells that will be added.
3. Hit enter.

That's it! Now that wasn't so bad was it? Following the same steps, you can add the totals for income as well.

Let me share a quick tip. When we entered the formula, we typed the cell reference B3:B7. If you prefer, you can highlight or select the range of cells you want Excel to add or SUM. The steps would look like this:

2. Type '=SUM('
3. Select or highlight the range of cells to add.
4. Type ')'
5. Hit enter.

Typing the cell reference is easy if the range of cells is small. However, if you had a long list of numbers and were not sure of the exact cell reference, using the highlight option comes in handy.

## Using SUM to Subtract

You can use other operators, such as subtract, in formulas that use the SUM function. In our sample worksheet, we have added the expenses and the income. Now we need to create a formula that will take the income, subtract the expenses and give us the amount of what is left over - or our spending money. In the case of our college budget, we would need to subtract B15(expenses) from B16(income). For this example, let's put the left-over dollar amount in B18.

2. Type =SUM(B16-B15).
3. Hit enter.

Perfect! Now we know how much extra money we will have for each semester.

To unlock this lesson you must be a Study.com Member.

### Register to view this lesson

Are you a student or a teacher?

#### See for yourself why 30 million people use Study.com

##### Become a Study.com member and start learning now.
Back
What teachers are saying about Study.com

### Earning College Credit

Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.