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:


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


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



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


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

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...
Calculate the Compound Interest with Excel’s... What does it do?Calculates the compound interestFormula breakdown:=FV(rate, nper, pmt, )What it means:=FV(interest rate, number of periods, periodic payment, initial amount)Say that you turn 18 years today (CONGRATS!) and you find out that your parents...
Extracting Data with Excel’s RIGHT Formula What does it do?It returns the last character or characters in a text string, based on the number of characters you specify.Formula breakdown:=RIGHT(text, )What it means:=RIGHT(look in this cell, extract X characters)There are times when you will need ...
Cleaning Data with Excel’s CLEAN Formula  What does it do?Removes all nonprintable characters from textFormula breakdown:=CLEAN(text)What it means:=CLEAN(this dirty text cell)There are times when imported text from other applications contain characters that are unprintable. The CLEAN...