1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

How to Add in Excel

Add Data Using a Formula in Excel

By

How to Add in Excel

How to Add in Excel

© Ted French

Adding Numbers in Excel

To add two or more numbers in Excel you need to create a formula. Two important points to remember about Excel formulas:

  • formulas in Excel always begin with the equal sign ( = )
  • the equal sign always goes in the cell where you want the answer to go

Use Cell References in Formulas

Even though you can use numbers directly in a formula, it is much better to use the references or addresses of the cells containing the numbers you want to add. If you use the cell references rather than the actual data, later, if you need to change the data in either cell, the results of the formula will update automatically without you having to rewrite the formula.

Setting Up the Addition Formula

As an example, lets create a formula in cell C1 that will add the data in cell B1 to the data in A1.

Our formula:

=A1 + B1

Our data:

  • place the number 20 in cell A1
  • place the number 10 in cell B1

Formula Steps

To add 10 to 20 and have the answer appear in cell C1:

  1. Type an equal sign in cell C1.
  2. Click on cell A1 with the mouse pointer.
  3. Type the plus sign ( ) in cell C1.
  4. Click on cell B1 with the mouse pointer.
  5. Press the ENTER key on the keyboard.
  6. The answer 30 should be present in cell C1.
  7. Even though you see the answer in cell C1, if you click on that cell you will see our formula in the formula bar above the work area.

Expanding the Formula

To expand your formula to include additional operations - such as subtraction, multiplication, or more additions- just continue to add the correct mathematical operator followed by the cell reference containing your data.

Excel Order of Operations

Before you mix different mathematical operations, be sure you understand the order of operations that Excel follows when evaluating a formula.

Related Video
Excel Autosum Function
Cell References in Excel

©2014 About.com. All rights reserved.