AutoSum


show more AutoSum provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

AutoSum

I really enjoy working with functions in Excel. So I set up EatCake Inventory15, so that we can explore some of the most commonly used ones. In each of the subsequent movies in this chapter, please open up the Inventory15 spreadsheet if you'd like, or just continue to work within that spreadsheet. The first function we're going to look at is the AutoSum function, and what that does is it adds up all of the numbers in a particular range. Usually it's a column, sometimes it's a row. And in this case, what I'm I want to do is I want to find the final cost for all of the items in this inventory.

So if you scroll down through the spreadsheet, you'll see that I've added a total cost column of the very bottom of column G. Now, the thing to remember when you're working with functions is you want to select the cell where the information's going to end up. so you kind of work backwards. You start at the place you want to end up. I want my answer to be in G27, so I cli...

AutoSum
Video duration: 2m 47s 5h 13m Beginner

Viewers:

AutoSum provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...