Related topics
×
Top tips for working in Excel for the web
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.
Top tips for working in Excel for the web

Three ways to add numbers

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

See 3 quick ways to add numbers in Excel for the web, including AutoSum for sequential numbers and the SUM function for rows or columns containing blank or text cells.

Note:  Excel for the web was formerly known as Excel Web App.

Want more?

Top tips for working in Excel Online Insert headers and footers

Let’s look at three ways to add numbers in my company’s sales spreadsheet.

Perhaps the easiest way is to select a set of numbers in rows or columns,

and look for the sum of those numbers down here on the status bar.

Another way to add numbers in multiple rows or columns is to use AutoSum on the Home tab.

I need to add the product sales from each quarter to find out the total sales for the year. way I can see which item is our best seller.

I select the first empty cells to the right of my rows of data.

I click AutoSum. Don’t worry if you get a column of hashtag symbols.

That just means that your column is too narrow for your set of numbers.

Double-click the right border of your column to expand the width, and the sales numbers will appear…

I’ll add a title to this new column.

I can do the same thing to get my quarterly totals. I select the first empty cells below each of my columns and click AutoSum.

And I’ll add a title to this new row of numbers.

The nice thing about AutoSum is it recalculates if you change numbers.

I have to correct this number, and when I do, both the yearly total and the quarterly total update automatically.

No need to fuss with formulas to recalculate.

AutoSum works best when you’re working with only sequential numbers – no blank cells or text.

If you do need to add rows or columns containing blank or text cells, create a formula with the SUM function.

A SUM function can add numbers, whether the cells are in a sequence or range, or just a bunch of individual unconnected cells.

I want to add these numbers, plus the number in this cell.

In an empty cell, I type the =, SUM, and an (.

Then I select this cell, and drag my selection to this cell.

To add to this formula, I type a , select the other cell, and then type a ).

The SUM function adds all the numbers in the range of cells and the individual cell I selected.

And just like AutoSum, if any of the cells change, the SUM function updates automatically.

Now you’ve got top tips for working in Excel Web App.

Of course, there’s always more to learn.

So check out the course summary at the end, and best of all, explore Excel Web App on your own.

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!

×