Related topics
×
Add numbers in Excel 2013
Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
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 and divide numbers in Excel

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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×