Add numbers in Excel 2013

Add numbers in Excel 2013

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

You can use Excel to add numbers using formulas, buttons, and functions.

Want more?

Add numbers

Subtract numbers

Multiply numbers

You can use Excel to add numbers using formulas, buttons, and functions.

Let’s take a look.

You add numbers in cells by using formulas.

A formula always starts with the equals sign. I then enter a number, then a plus sign, then another number, and press Enter.

And the cell displays the results.

You can add many numbers this way, not just two.

Instead of adding numbers within a cell, you can also reference cells to make adding a bit easier.

B2 is equal to 6, B3 is equal to 3

I’ll create a formula that adds the cells.

I start with an equals sign, click a cell that I want to add, then a plus sign, and then another cell, and press Enter.

If I change a number in a cell, the results automatically update.

You can also add many cells this way, not just two.

You can even add cells and numbers.

I start with the equals sign, click a cell I want to add, then a plus sign, then another cell, then another plus sign, the number, and press Enter.

When you double-click a cell, you can see if it has a number or a formula, or you can look up here in the Formula Bar.

AutoSum makes it easy to add adjacent cells in rows and columns.

Click the cell below a column of adjacent cells or to the right of a row of adjacent cells.

Then, on the HOME tab, click AutoSum, and press Enter.

Excel adds all of the cells in the column or row. It’s really handy.

The keyboard shortcut for AutoSum is Alt + =.

You can even select an adjacent group of cells and an extra column and row. Click AutoSum and you get the sum for each row and column, and a grand total.

AutoSum has a number of options.

Choose an option, such as Average, and Excel calculates the average for the row.

To copy a cell and its formula, click the cell, click the bottom right of the cell border so that you see a plus sign, hold down your left mouse button and drag it to the right for a column or down for a row.

And the formula is copied into the new cells.

Up next, the SUM function.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×