What does it do?

Adds two numbers

Formula breakdown:

=number1 + number2

What it means:

=the number being added to + the number being added


In Excel adding numbers together is really easy with the Addition Formula which uses the addition operator: +

I will show you in the steps below how you could add numbers together in your Excel worksheet.

This is the table of values that we want to perform addition on:

Addition Formula in Excel

I explain how you can do this below:

DOWNLOAD EXCEL WORKBOOK

STEP 1: We need to enter the number we want to add:

=C9

Addition Formula in Excel

 

STEP 2: Enter the addition operator +

=C9 +

Addition Formula in Excel

 

STEP 3: Enter the number to add:

=C9 + D9

Addition Formula in Excel

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

You now have all of the addition results!

Addition Formula in Excel

How to Use the Addition Formula in Excel

Addition Formula in Excel

HELPFUL RESOURCE:

How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

CountBlank Formula in Excel What does it do? Counts the number of cells that are blank Formula breakdown: =COUNTBLANK(range) What it means: =COUNTBLANK(range of cells to check) Do you have a scenario where you want to count the number of cells that are blank in your Excel data? If y...
Getting the remainder with Excel’s MOD Formu... What does it do? Gives you the remainder after dividing one number with another Formula breakdown: =MOD(number1, number2) What it means: =MOD(a number, divided by this number) In Excel it is very easy to divide two numbers. But how about if you need to ge...
CountIfs Formula in Excel What does it do? Counts the number of cells that matches your specified conditions Formula breakdown: =COUNTIFS(range1, criteria1, , , ...) What it means: =COUNTIFS(range of cells to check1, condition to check against1, , , ...) Do you have a scenario where ...
Add Leading Zeros in Excel Do you have a lot of numbers with an uneven number of digits in your Excel list? Do you want to make them uniform by adding leading zeros to them? Well, it's a pain to add zeros in front of them one by one! Thankfully, Excel allows you to add leading zeros with one singl...