Hello and welcome to a new video
In this video we are going to do that how to use the
formula of sum or how to do sum so your question is that
sir in last video we have done sum but in this video I will
tell you that there is no way to do sum there can be
different ways to do sum so all those ways to do sum we
will see in this video rest if you want to do subtraction
multiplication or division on all those formulas you can
apply the same thing which we are going to see today so
let's start what we are going to do today so I
an excel file in which I have some data student's name,
serial number and some marks sociology marks, math marks,
geography and here is a total column so what I have to do
first of all we will see that way which we did in last
video what we did in last video we did that if I want to do
sum for example if I want to do sum of div total marks so
what will happen 10 plus 35 plus 26 plus 49 so what I will
do
I used to take cursor of my mouse on this cell what I used
to do
I used to click on left button and I used to drag it like
this and in extra cell I used to select so that I can get
result so after selecting all those cell what I used to do
I used to click on auto sum and here
I used to get result so this was the traditional way which
we used in last video but what we are going to do in this
video so before doing something new
I want to tell you some things which will help you so we
have read two things in last video we have seen this name
box and we have seen this formula bar so we will revise
these two things for example
I want to ask you what will be the name of this particular
cell so one thing is that I selected this cell and here I
got name D4
I selected this cell and here I got name F6 but if I tell
you that you don't have to look at name box and if I click
here and you tell me right so how will they tell you so
first of all the name of any cell first alphabet for
example G6 so in this G is column and 6 is row so what we
have to see if I ask you the name of this particular cell
so you have to see which one is long second number is row
so what will be the name of this particular cell
H2 one more example if I ask you the name of this
particular cell so what will you say
I have to see column and then I will see which one is row
so what will be the name of this particular cell
G6 so here is G6 is it clear so why we are emphasizing so
much that you should know the name of this particular cell
we will see that one way we got to know
I will remove this we will see another way in another way
what you have to do there will be a sign of equals to
I will show you on your keyboard this is your keyboard this
is the sign of equals to what you have to do you have to
click this sign when you click this sign what you have to
do then you have to write SUM now what is shown below this
is related to sum we will use all this later this
particular formula so what we have to do we have to select
this one then we have to use parenthesis what is parenthesis
I will show you on your keyboard on your keyboard you can
see this kind of bracket left and right we are going to use
these two brackets
I will put bracket here after that what I have to do now I
have to see how much sum I want
I have to tell the range
I want 10 plus 35 plus 26 plus 49
I want sum of these four so what I will do this is the
starting point
I will put the name of that column what will be the name of
this column
C2 now we are looking for divinity so you will see this
area is highlighted now what I have to do
I have to put colon these two brackets on your keyboard
I will show you these two brackets you have to use after
that I have to put last cell this is serial number 1
student's name is Divyani sociology mark 10, math 35,
geography 26 so what I have to do
I have to put the name of first cell and last cell these
two cells will be automatically selected now what is the
name of this cell
F this is divinity row if I ask you what will be the name
of this cell you will say F so F is column and cell is 2 so
I will write F2 after that
I will close this bracket now you will see these two cells
are also selected now what I have to do
I have to enter now what you have to do now you can do this
for Siddharth you can do this for Ashok you can do this for
Jagdamba for example if I want to do this for Siddharth now
you can do this for Siddharth you will put sign of equal
sign then you will write sum then you will put left bracket
you are calculating the data in Siddharth so what will be
the name of this cell we know how to find out
C3 then you will put colon and last cell this is F3 you can
do like this if you click with mouse now you have to close
this result is 188 now the question is do I have to do this
for all do I have to write sum here no student data suppose
if it is 900 do I have to write sum then put name of first
cell you can't do like this so what is the better way do
you remember we read the list what we do in list if I have
to write name of two then I will put sign of plus but here
you don't have to
two data for example we know the formula see here
C2 F2 and drag it then automatically formula will change
for this it will be
C3 and F3 let me show you as I drag it see the answer is
188 now if you select it then see what is here
C3 F3 clear? so what I have to do is
I have to calculate one cell
I have to put formula in one cell and what I have to do in
other cells
I have to come here and drag it and all my data will be
automatically calculated so all this data is calculated is
it clear? now let's see suppose if I make some changes here
so will there be changes in real time here also? how much
is here? 153 if I change it from 6 to 10 so will there be
changes here? see what is here? 157 56 56 to 10 10 to 157
157 clear? let's do it again 65 60 243 and you can see what
is here
C7 and F7 what is C7? what I selected from here
I am not selecting it
I just put formula here and what I did in other cells
I dragged it and put formula is it clear? now let's see
here someone told you you have removed
Divyani's marks now what you have to do you have to
calculate all marks of sociology and tell total sum so we
know how to calculate so don't get confused what we did to
calculate here first cell was selected and last cell was
selected all the cells in between were automatically
selected so here also what we have to do first cell is
selected and last cell is selected if I ask you name of
first cell it will be C2 what will be name of last cell?
C10 so what I have to do here equals to and now
I put name of first cell what is name of first cell?
C2 and what is name of last cell? last cell's name is C10
ok we closed it so total is 450 now here we calculated and
drag it so can we drag it here also? that I put formula
once so can I put same formula on all these? answer is yes
you removed it see plus sign here now drag it here
it shows you all 6123314031796
now wherever you change for example here here also see here
I put 10 so see here also changed is it clear? so what is
this? second method in second method we put formula ok
let's see next method what is next method?
I delete this data now question is how to delete all this
data? select it with mouse and on your keyboard delete
button will show for example here this is delete button
what you have to do? press delete button for example
I delete all data you can do like this here I select all
and delete is it clear? now next method not formula what is
method?
I write equals to sum here I put bracket and after this
what I am trying to do?
I am selecting cells
I am selecting with mouse what I did here?
I selected with mouse and here I closed bracket and entered
see 120 came now once formula is applied we know what we
have to do here we have to see plus sign and what we have
to do? drag it down so all my calculation will be done so
these three methods are clear after this let's see fourth
method suppose someone told you that you have to do one
thing you have to calculate divyani's sociological and
geographical marks you have to add them and sum them you
don't need anything else so what we have
do? we know how to do so what we have to do? now you don't
need to apply formula when you have less data like we have
four subjects so in four subjects we know that we have to
know cell's name like someone told us that divyani's
sociological marks and geographical marks you have to add
them so we know that this cell's name is
C2 and this cell's name is F2 so what we have done?
C2 and plus
F2 now what it will do? highlight so here 10 plus 49 we
have to enter what is this? 59 will it work on rest? let's
see here 20 67 will it work on this? no, it will work on
this 20 plus 39 exactly it is working here 30 plus 25 how
much? 55 it is working on this means once you apply formula
or you add two cells then it will work on every cell is it
clear? after this let's see what is the last method? delete
press delete button now I don't have to write sum till now
I was writing sum now I have to
equals to directly like last method in last method we have
seen directly C2 plus
F2 but in 5th method we can do it inside sum like we wrote
sum we did this and inside this we wrote C2 plus F2 then I
wrote plus
F2 then I entered so here is your 50 rank now if I drag it
then what it will do? automatically calculate is it clear?
we have seen 4-5 methods with which we can use sum now you
can use this in subtraction you should know cell name if
you want to add this cell then you can do this delete
suppose this is 50 what will be the name of this cell?
I have seen column C and row
C6 and this column is F7 so what I have done here?
I have done here equals to
C6 automatically selected you can calculate in any cell
C6 plus
F7 plus F7 and I have entered result is 110 is it clear?
and always remember if you know the name of cell then you
can do things easily and formula formula is shown in bar is
it clear? that's all for today keep practicing till next
video