- [Instructor] Excel has a feature called AutoSum,
and it's so useful, it's on the Home ribbon tab
right here on the right hand side.
We spend so much time doing data entry.
Of course, we'd want to see the value of that data
that we're putting in, and we can do that easily
with AutoSum.
Let's take this.
During January, these are all the units sold
for my products.
If I want to find out the total amount of products
that were sold during January,
I can place the cursor here at the bottom
of all my data and click the AutoSum button
on the top right hand side of the Home ribbon tab.
It's going to put in the formula.
In fact, here I can see that it's just done my work for me.
It's put in the sum function,
and it's summing cell B2 through B6.
All I have to do now is hit the enter key,
and there's my total.
A nice thing about AutoSum,
and I'll delete this,
is that I can sum everything all at once.
I'm going to click and drag with my mouse
to select all of these cells.
If I click the AutoSum button again,
it's going to instantly populate with those totals.
In fact, if I click inside each cell,
I can look in the formula bar
and see what it's calculating.
For example, here in March, I can see
that it's summing column D.
In February, it's summing column C, and so on.
The really neat thing about AutoSum
is that it's not just for summing.
If I click the down arrow next to AutoSum,
I can find the average,
I can count all the numbers,
find the max and min,
and get even more functions that I can do.
For example, let's find out the highest units sold
during January.
AutoSum also works going vertically.
Let's come here to the end
and do a different tally.
This time, I want to see the total amount of units sold
per product, so I'll select the cells this way
and click AutoSum again.
This time, we get a completely new set of sums
because it's summing across,
and again, I can easily do the same thing.
I can find the averages, the highest values,
or the lowest value.
I can also copy my own formulas
if I've worked hard to create one myself,
and it doesn't have to be a sum.
It can be anything.
This time, though, just to make things easy,
I'll type in my sum formula manually,
equals sum,
and I'll click and drag to select these cells
and close the parentheses.
Here's my value.
But remember AutoFill?
When we hover the mouse over the bottom right hand side
of a cell, it's going to change to a plus sign,
that cross hair icon, and when that happens,
I can click and drag all the way across.
What that's going to do is copy the formula
all the way across.
Now, as you can see, if I click on each cell,
I can see the different sums.
As a matter of fact, I can double click inside a cell,
and it's going to show me the exact same formula.
So we can either look at it in the formula bar up here,
or I can double click on the cell.