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

Division Formula in Excel What does it do?Divides two numbersFormula breakdown:=number1 / number2What it means:=the number being divided / the number you are dividing byIn Excel dividing numbers together is really easy!The Division Formula is done through the use of the div...
Extract Last Name with Excel’s REPLACE Formula What does it do?Replaces part of a text string, based on the number of characters you specify, with a different text stringFormula breakdown:=REPLACE(old_text, start_num, num_chars, new_text)What it means:=REPLACE(this cell, starting from this number, all the ...
CountIf Formula in Excel What does it do?Counts the number of cells that matches your specified conditionFormula breakdown:=COUNTIF(range, criteria)What it means:=COUNTIF(range of cells to check, condition to check against)Do you have a scenario where you want to count the num...
Round Off Numbers with Excel’s ROUND Formula What does it do?Rounds a number to the nearest decimal based on your specified number of digitsFormula breakdown:=ROUND(number, num_digits)What it means:=ROUND(the number, number of decimal places to round off)Ever had the need to round off numbers? ...