Select your Top Menu from wp menus

12 Excel FUNCTIONS Made Easy [SUM, SUMIF, COUNT, COUNTIF, MAX, MIN…..]

► THE MOST USED
► FUNCTIONS IN EXCEL ARE THE ONES THOSE
► SUM AND COUNT IN THIS EXAMPLE WE’LL SEE
► HOW TO USE THE SUM AND COUNT FUNCTION IN
► A VARIETY OF WAYS LET’S SAY WE HAVE A
► MOCK SHEET OF STUDENTS WHERE THEY WERE
► PAIRED FOR THREE EXAMINATIONS ENGLISH
► MATH AND SCIENCE THE TOTAL MARKS FOR
► EACH SUBJECT IS AND THESE ARE THE
► SCORES THAT EACH OF THEM IS OBTAINED SO
► NOW WE WILL SEE HOW TO GET THE TOTAL
► MARKS FOR EACH STUDENT WE CAN USE THE
► SUM FUNCTION TO GET TO CALCULATE THE
► TOTAL MARKS WHAT WE DO IS AND THEN CELL
► F WE CAME EQUAL TO SUM AND THEN CLICK
► ON THE FUNCTION ARGUMENTS DIALOG BOX
► OVER HERE AND REFERENCE THESE NUMBERS TO
► ENGLISH MATHS AND SCIENCE
► SO THIS IS ALAN’S TOTAL NOW WE’LL SIMPLY
► DRAG THIS DOWN TO OUR THE STUDENTS AND
► THIS IS HOW WE GET THE TOTAL MARKS FOR
► EACH OF THEM NOW WE WILL SEE HOW TO GET
► THE AVERAGE MARKS FOR EACH OF THE
► STUDENTS SO TO GET THE AVERAGE WE USE
► THE AVERAGE FUNCTION AND CLICK ON THE
► BUTTON OVER HERE TO OPEN THE FUNCTION
► ARGUMENTS DIALOG BOX AND THESE ARGUMENTS
► WOULD BE THE INDIVIDUAL SCORES IN
► ENGLISH MATHS AND SIGNS AND CLICK ON OK
► AND HERE WE GET THE AVERAGE MARKS FOR
► ALAN AS YOU KNOW WE CAN SIMPLY DRAG IT
► DOWN TO GET THE AVERAGE MARKS FOR EACH
► OF THE STUDENTS RIGHT SO NOW WE WILL SEE
► HOW TO GET THE GRAND TOTAL FOR EACH OF
► THE SUBJECTS SO HERE WE CAN YOU KNOW USE
► A SHORTCUT TO GET TO THE TOTAL FASTER
► INSTEAD OF YOU KNOW GOING THROUGH THE
► FUNCTION ARGUMENTS DIALOG BOX AND DOING
► IT ONE BY ONE WE CAN SIMPLY USE THE ALT
► EQUAL TO SHORTCUT AND GET TO THE TOTAL
► AND JUST A SECOND
► SO SEE
► NOW WE CAN
► SIMPLY DRAG THIS TOTAL TO THE OTHER
► SUBJECTS TO GET TO THEIR RESPECTIVE
► GRAND TOTALS SO WHAT IS THE SEAT ASKING
► NEXT IT IS ASKING WHAT IS THE NUMBER OF
► STUDENTS NUMBER OF STUDENTS CAN BE
► CALCULATED USING THE COUNT A FUNCTION SO
► COUNT A WOULD SIMPLY GIVE YOU A COUNT
► FOR ALL THE NON BLANK CELLS IN THE RANGE
► WHICH MEANS THAT IT WOULD BE TAKING A
► TOTAL LOG YOU KNOW ANYTHING APART FROM
► NUMBERS AS WELL HAD WE USED THE COUNT
► FUNCTION OVER HERE WE WOULD HAVE GOTTEN
► WE WOULD HAVE GOT A ZERO VALUE AS THESE
► ARE NON NUMERIC VALUES RIGHT SO COUNT A
► FUNCTION WOULD BE USED IN SUCH A CASE
► NOW MOVING ON TO THE NUMBER OF SUBJECTS
► NUMBER OF SUBJECTS CAN BE CALCULATED
► USING THE COUNT A FUNCTION AGAIN COUNT A
► FOR THE SUBJECTS WHICH WILL GIVE US AN
► ANSWER NOW THE
► QUESTION HERE IS TO CALCULATE THE
► MAXIMUM MARKS IN EACH OF THE SUBJECTS SO
► TO GET TO THAT WE’LL USE THE MAX
► FUNCTION MAX FUNCTION WOULD HELP US GIVE
► US THE HIGHEST VALUE IN THE RANGE WHICH
► IS HAS BEEN OBTAINED BY JOHN IN
► ENGLISH AND THIS IS THE HIGHEST RIGHT SO
► NOW WE CAN SIMPLY DRAG THIS TO THE OTHER
► TWO SUBJECTS TO GET TO THEIR RESPECTIVE
► MAXIMUM MARKS AND THIS CAN ALSO BE
► DRAGGED TO THE TOTAL MARKS TO GET TO THE
► MAXIMUM OBTAINED TOTAL MARKS SIMILARLY
► WE NEED TO CALCULATE WHAT IS THE MINIMUM
► OBTAIN MARKS ON EACH OF THE SUBJECTS AND
► WE’LL USE THE MIN FUNCTION FOR THE SAME
► EQUAL TO MIN SELECT THE ENTIRE RANGE
► CLICK ENTER SO IS THE MINIMUM MARKS
► IN ENGLISH AND IT WAS OBTAINED BY A
► MONTH ALL RIGHT SO WE CAN NOW DRAG THIS
► WITH OTHER SUBJECTS AND TO THE TOTAL YOU
► WILL SEE IN MATH AND IN SIGN TO
► THE LOWEST IS THE LOWEST GRAND TOTAL
► OR TRACKING US HOW MANY NUMBER OF
► STUDENTS HAVE OBTAINED MORE THAN
► MARKS IN EACH OF THE SUBJECT SO FOR THIS
► WE’LL USE THE COUNT IF FUNCTION WHERE
► THIS WILL BE A RANGE AND A CRITERIA
► WOULD BE GREATER THAN SO AS WE CLICK
► ON OK WE GET THE RESULT AS FOUR SO FOUR
► STUDENTS HAVE GOT MORE THAN MARKS IN
► ENGLISH AND THIS CAN BE DRAGGED ON TO
► THE OTHER SUBJECT TO GET TO THEIR
► RESPECTIVE ROUNDS SO SIMILARLY WE CAN
► GET THE COUNT OF HOW MANY NUMBERS OF
► STUDENTS WHO HAVE FAILED SAY THE PLASMA
► IS SO WE CAN USE THE COUNT
► FUNCTION GIVEN THE RANGE AND THE
► CRITERIA AS LESS THAN AND CLICK ON
► OK.NOW WE SEE THAT ONLY ONE STUDENT HAS
► FAILED IN ENGLISH DRAGGING IT DOWN TO
► THE OTHER SUBJECTS WE SEE THAT TWO HAVE
► FAILED IN MAX AND TWO ENZYMES SO OUR
► NEXT QUESTION ASKS US TO GET THE TOTAL
► MARKS OF STUDENTS WHO HAVE GOT MORE THAN
► MARKS IN MATHS SO THEN NOW WE’VE BEEN
► WORKING WITH A SINGLE CRITERIA BUT IN
► THIS QUESTION WE SEE THAT WE HAVE MORE
► THAN ONE CRITERIA THAT IS WE NEED TO GET
► THE TOTAL MASS OF THE STUDENTS WITH
► MARKS PLUS IN MATH RIGHT SO HOW TO GET
► TO THIS WHEN WE ARE DEALING WITH
► MULTIPLE CRITERIA WE NEED TO USE THE SUM
► IF FUNCTION SO SOME F’S FUNCTION WILL
► ASK FOR SOME RANGE THAT IS WE NEED TO
► FIND THE SUM TOTAL SUM OF TOTAL MARKS
► WHETHER CRITERIA RANGE ONE IS THE MARKS
► IN MATHS AND THE CRITERIA IS GREATER
► THAN RIGHT SO WE CLICK ON OK
► AND WE GET WHICH MEANS THAT THE
► TOTAL MARKS OF ALL THE STUDENTS WHO HAVE
► GOT MORE THAN MARKS IN MATHS COMES TO
► WE JUST CHECK HOW SO WHO ARE THE
► STUDENTS WHO HAVE GOT MORE THAN IN
► MATCH TOM JOHN SUFFER KUWAIT AND PRINCE
► SO THEIR TOTAL MARKS ARE TWO ONE EIGHT
► TWO TWO FIVE TWO ZERO EIGHT ONE FORTY
► AND AND SEE THE SUM TOTAL OF THIS IS
► GOT IT SO THIS IS HOW WE DEAL WITH
► CASES WHICH HAVE MORE THAN ONE CRITERIA
► AND USE THE SUMMIT’S FUNCTION FOR THE
► SAME SO SIMILARLY WE CAN FIND OUT THE
► AVERAGE OF ALL THE STUDENTS WHO’VE
► BOUGHT MORE THAN MARKS IN MATHS WE
► WILL USE THE AVERAGE ITS FUNCTION FOR
► THE SAME
► SO THE AVERAGE RANGE IS THIS CRITERIA
► RANGE IS THIS AND THE CRITERIA IS
► GREATER THAN CLICK ON OK TO GET TO
► THE AVERAGE MARKS OF ALL THE STUDENTS
► GREATER THAN MARKS IN KNOTS NOW WE
► WILL SEE HOW TO GET THE NUMBER OF
► STUDENTS WITH MORE THAN MARKS IN ALL
► THE SUBJECTS SO FOR THIS WE’LL USE THE
► COUNT ITS FUNCTION
► THE CRITERIA RANGE WE THIS WITH A
► CRITERIA OF MORE THAN THIS IS OUR
► FIRST CRITERIA THE SECOND CRITERIA IS
► THE MARKS IN MATHS MORE THAN AND THE
► THIRD CRITERIA IS THE MARKS IN SIGNS
► SO IN THIS CONDITION WE ARE SEEING THAT
► WE ARE HAVING MORE THAN ONE CRITERIA
► ACTUALLY THREE CRITERIA THAT WE ARE
► DEALING WITH TOGETHER CLICKING ON OK WE
► GET THE ANSWER AS THREE SO THERE ARE
► THREE STUDENTS WHO HAVE GOT MORE THAN
► MARKS IN ALL THE SUBJECTS SO THE NEXT
► QUESTION WANTS US TO GET THE TOTAL MARKS
► OF ALL THE STUDENTS WHO HAVE GOT MORE
► THAN IN ALL THE SUBJECTS THE PREVIOUS
► QUESTION WANTED US TO COUNT THE NUMBER
► OF STUDENTS THIS ONE IS ASKING US TO
► TOTAL THE MARKS OF ALL THE STUDENTS WITH
► MODERN MARKS IN ALL SUBJECTS SO HERE
► WE WILL USE THE SUM IFS FUNCTION TO GET
► TO THE ANSWER THE SUM IS THE SUM RANGE
► BEING TOTAL MARKS THE FIRST CRITERIA
► RANGE BEING THE MARKS IN ENGLISH AND THE
► CRITERIA BEING GREATER THAN THE
► SECOND CRITERIA RANGE IS THE MARKS IN
► MATHS THE CRITERIA OF MORE THAN AND
► THE LAST CRITERIA RANGE IS THE MARKS
► ENSIGNS CRITERIA BEING MORE THAN
► RIGHT
► SO NOW WE CLICK ON OKAY AND GET THE
► TOTAL MARKS OF STUDENTS WHO HAVE GOT
► MORE THAN ALL THE SUBJECTS NOW LET US
► ALSO SEE HOW TO GET THE AVERAGE OF TOTAL
► MARKS OF ALL THOSE STUDENTS WHO HAVE GOT
► MORE THAN IN ALL THE SUBJECTS SO WE
► AGAIN APPLY THE AVERAGE IF CONDITION
► THAT WE JUST LEARNT OVER HERE SO AVERAGE
► IS THE AVERAGE RANGE WOULD BE THE TOTAL
► MARKS THE FIRST CRITERIA RANGE WOULD BE
► THE MARKS IN ENGLISH THE CRITERIA BEING
► GREATER THAN SECOND CRITERIA RANGE
► WOULD BE THE MARKS IN MATCH CRITERIA
► BEING MORE THAN AND THE THIRD
► CRITERIA RANGE BEING THE MARKS AND SIGNS
► CRITERIA BEING MORE THAN NOW WE’LL
► CLICK ON OK AND WE’LL GET THE AVERAGE OF
► ALL THE STUDENTS FOR WHAT MORE THAN
► MARKS IN ALL THE SUBJECTS

VIdeo Link

 

About The Author

Related posts

Leave a Reply

Your email address will not be published. Required fields are marked *