(gentle music)
- [Instructor] All right. If you're using Google Sheets,
so we have this little table right here
and you want to use something that you're used to,
probably from Excel called Autosum.
We'll look at Autosum for a second,
show what you're like looking for. Okay?
So let's say we wanted to sum this range of data,
you can select an empty cell right below it.
Autosum is smart enough to know
that it's at the bottom of a column of data.
Left click on Autosum, it wants you to confirm
that it's chosen the right range.
And if you hit Enter, it's confirming that it's right.
And it is summed this column of Data.
All right. There's something else that Autosum can do,
is it can kind of guess what you want to do.
So if I were to highlight this range
and then highlight the column right to the right of it,
it would guess that you want to add these two together
and have an entire column of new numbers.
Okay. Well, in this case,
I actually want to multiply these
because this is a units times unit costs
but Autosum just does sum
and there are some other options available,
but in this case, we want to do multiply.
So it's showing a little bit of the limitations
of Autosum there.
We will delete that and we're going
to look at how this works in Sheets.
First of all, go through the built-in way.
If I pre highlight it and I leave an empty space
and I left click on Functions, sum is the first choice,
so this doesn't default to thinking that you want sum,
but sum is there, so let's click on that.
And it will pre-fill the range,
should have acted a little wonky there,
it bumped this down one.
So what we're going to do is escape
and it's probably designed to just select the cell
right at the bottom.
We'll try it again. We'll go to sum.
And it gives us an empty range.
So in this case, we will fill it up,
and there's your sum.
So this isn't really Autosum,
it's more of pre-populating the SUM function in there
and then you fill it in.
We'll try one more way,
we'll just highlight the column and we'll do sum.
So that's probably the way that's designed to work.
All right. So we'll hit Enter,
but that's still a little bit limited
if you wanna have closer to the Autosum functionality
and you essentially just want to skip steps
and work faster in your spreadsheet.
We'll look at an add-on from Power tools
and we'll just start it up.
It'll give us a menu on the right hand side
of all of these shortcuts set that it offers.
And while that's loading, if you want to check this out,
please use the affiliate link in the description,
it will bring you to a page with the information
and it'll also build in a discount for you.
So we've gone over some of these other abilities
in previous videos.
I'll put a playlist to those on the screen
and you can check those out.
But right now we're going to go into the formula section.
And there's lots of little things in here that can help you
but right now we're just going to look at Autosum.
All right. So I've given away a little trick
that I'm going to show here.
It would default to sum
and let's just try it right now while we're on it.
And it's going to sum just this column, easy as that.
All right. So it was able to detect
where the column of Data was and it put in the sum.
So on this next column, summing the unit cost, let's say
that's not going to give us very helpful information
but we're curious of what the average is, right?
So if we just do Autosum but change it to average,
so really kind of auto-average,
it's going to run that calculation as well.
And you notice I haven't typed in a single formula yet.
So we'll bring this kind of to the next level
as far as how I think about it, we're going to say,
'Hey, let's get this column'.
And we're just doing this by selecting the cells.
You can do it by holding down your mouse button
and dragging or you could use your keyboard
in the Shift and Arrow keys as well.
I'll link to a little video on keyboard shortcuts
that I did if you wanna see how to do that.
I will go to the right one
and then we'll go to the right another one.
So we're telling this add-in,
we want to look at these two columns
and we want the Data placed in this empty column.
All right. So this is going to go left to right in each row,
it's not going to go down in the columns.
And it's units times unit costs.
We want to multiply these two to get the product
which will be the total price.
So we'll change Autosum to product and then click Run,
run that function in every cell.
So we'll double click on these,
it's using the product function
which is multiplication all the way down.
And in this next video,
we'll use the option in here to calculate cells
based on their colors.
So I'll see you in that next video.
Thanks for watching.