I'm going to show you a quick way to use
an entire column in a cell range you can
use this in many situations for example
finding the sum or average of all of the
values in the column let's say I want to
find the sum of all of the January sales
first I'll type sum and open parenthesis
and then to create the argument we're
going to click near the column letter in
this area is called the column heading
it's added C : C to our formula which
may look a little bit different from
other cell ranges that you've seen but
it means it's going to pull in all of
the cells in column C close the
parentheses and press Enter
and there's our some let's try one more
with the average function
if we want to find the average of the
March sales we'll just click at the top
of column E so our argument is e : e and
you can type this or click the column
heading it's really up to you then just
close the parentheses and press Enter
and there's our average
I'm going to double-click the formula so
we can take a closer look if I scroll
down you can see that it selected the
whole column including all of the empty
cells below the data this is good
because it means we can add more data
later on and it will automatically be
included in our formula on the other
hand it also means we need to make sure
that we're not adding any kind of
unrelated data here that we don't want
included so you do have to be careful
when you're using a whole column in a
cell range but it's still a great
shortcut to use
Goodwill Community Foundation creating
opportunities for a better life