Working with numbers in columns

Now if you've completed the exercise on adding a whole worksheet at once or…one of the AutoSum movies, you should have a worksheet that looks something like this.…So we have our Totals column.…We added across all the rows.…We have the totals down here.…We added down all the columns.…But there are a few other things that we might want to know about these numbers.…So let's click down here in Cell A15 and type the word Average.…We want to know what the average is of these numbers. I'll just press Tab.…So we'll use the Average function.…I'll type =Average. Now by the time I type the first four letters of the word…average, you see Excel is suggesting that I probably want the Average function.…

So I'll just press the Tab key and Excel will fill in the rest.…So we want the average of what?…Well, we want the average of these numbers in January.…So just drag over those numbers.…Be sure you don't drag anywhere below Row 12.…You just want San Francisco through Boston, and that's it.…Just press Ctrl+Enter and it gives us that average.…