00:00in this video i will show you different methods of calculating total in excel if you have very
00:05few numbers then you can use the direct formula method press equal to click on the first number
00:11plus click on the second number press enter this is the total if you have multiple numbers to add
00:19then you can use the sum function press equals type sum bracket open in the number one select
00:26this range close bracket hit enter this gives you the total if you have to calculate the total from
00:34multiple range like here i need the total of january and april then i can use the formula like
00:41this press equals put sum function open bracket in the number one select january quantity range
00:48put a comma in the number two select april quantity range close bracket press enter this is the total
00:57if the total to be calculated range is just below the number range then you can use the auto sum for
01:03that select this range including the total then press alt equal to in the keyboard this will
01:10automatically insert the sum function and calculate the total like and follow this account for more
01:17tutorials on microsoft excel
Comments