I'm going to show you how to make a dynamic range in Excel so we have a
sheet here and it's got 25 36 41 44 and so what we're going to do is we'll just
select these values and we'll call them random numbers okay and press Enter and
so then if we wanted to we can use name the range we should do things like um
and some and then you you enter random numbers and then you close your bracket
and then you're good and that's the sum of those numbers now so if these
numbers are changing if you add another nut another number to this list
you wouldn't it wouldn't change it we need to add that one on and so what
we're gonna do is we're gonna change that and what we're going to do is we
are going to I'm going to show you how you is done and basically it's based on
two formulas one is the counta which is asking you how many non blank characters
are in this role so what we're gonna do is we'll we'll show you count a so in
the e column I'm gonna run the count a function which is going to define or
tell me how many non blank non blank cells I have in this column so I give it
a colon dollar sign name so it's gonna tell me within the a call how many non
blank there are and so we'll say okay and you can see that it's telling you
for and so what you're gonna do is you are going to define your range by using
this function here so what we're going to do is we've named this range
we've range name this range random number so we're going to go to the
formulas the formula tab here and we're going to name manager so what I'm going
to do is I am going to build my formula with the function argument box so that
you can see what I'm what I'm trying to do and this is what I'm going to put in
the name name manager so the reference cell is anyone and we're gonna
absolutely reference that okay and the rows rows are 0 and the columns are zero
and we're doing it off set here and the height this is where we put our count a
function in so what we're gonna do is we're gonna go count a and we're going
to go a dollar sign a pulling dollar sign a and in bracket so that's always
gonna change and the width is one okay so I'm gonna say okay now this is not
what we're what we're trying to do but this explains the formula that I'm going
to enter in my name box so what we can do is we'll say okay and then what I'm
going to do is I'm going to select select this formula and copy it and then
I'm going to go
and then I'm gonna go to my name manager and I'm gonna go to random numbers and
I'm gonna edit it and then I'm gonna put this formula in here and say ok and
close okay so now with this formula in here if I put another number in here
notice my 146 is gonna change to 201 and my the count a is gonna change to 5 so
that's how you make a dynamic range please subscribe