Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

You are here

Home › Videos › How to use addition in a formula

How to use addition in a formula

Transcript 

In this lesson, we'll take a quick look at how to use addition in Excel. To add things in Excel, use the "+" sign.

Let's take a look.

Here we have a simple worksheet that highlights several cell references. Following the instructions in the table, let's build simple formulas that use addition.

The first two examples don't require any cell references and can be input directly. Always use an equal sign "=" to start off the formula:

to add 1 and 5, we enter:  = 1 + 5
to add 23 and 47, we enter:  = 23 + 47

For the next formula, we need to add C9 and D6. We'll simply type this in directly as = C9 + D6

Next we have H11 plus F7. This time, we'll point and click to set the cell references. Notice we get a negative value, since the value in H11 is -10.

Finally, we need to add together all cell references.

We'll use our mouse to indicate the references. We can check that we entered the references correctly by double-clicking, or by clicking into the formula bar.

You could see a VALUE error if any of the cells contain text. Empty or blank cells will not cause an error.  Excel will treat blank cells as "0."

Master Excel with practice. Download this worksheet (and dozens more) in our Core Excel course. Learn by doing.

Dave Bruns Profile Picture

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Microsoft Most Valuable Professional Award  

Exceljet Training

  • Excel 101
  • Excel Fundamentals
  • Conditional Formatting
  • Essential Formulas
  • Advanced Formulas
  • Pivot Tables
  • Excel Tables
  • Excel Shortcuts
  • Excel Charts
  • Course Bundles
I am just loving exceljet. Honestly THE best money I ever spent! What is so good about this resource is that it is in short, specific video clips, with both audio and text and with practice downloads for hands-on experience. I like the way you highlight what you are talking about in orange, and it isn’t too fast that the eye can’t see it before you move to the next thing! I love how you provide instructions for the absolute beginner right through to really advanced things.
Anne
More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact
  • Donate

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2025 Exceljet. Terms of use
  • Visit our Twitter page