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.
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.