12 Excel FUNCTIONS Made Easy [SUM, SUMIF, COUNT, COUNTIF, MAX, MIN.....] | ExcelJunction.com

Practice file for DOWNLOAD: www.exceljunction.com/12-excel...
The most used functions in Excel are the ones that sum and count. You can sum and count based on a single or multiple criteria. This lesson covers:
SUM, SUMIF, SUMIFS, COUNT, COUNTA, COUNTIF, COUNTIFS, AVERAGE, AVERAGEIF, AVERAGEIFS, MAX, MIN

Пікірлер: 380

  • @manojkumar-gk6dd
    @manojkumar-gk6dd5 жыл бұрын

    This is explained in such a simple manner, thank you, sir ............

  • @nabrii1924
    @nabrii19245 жыл бұрын

    Am so much grateful, the turtorials are so helpful. It was hard to understand my college tutor in limited time. Now I have found stressfree help.

  • @how-2116
    @how-21165 жыл бұрын

    You are good teacher, thank you for this video.

  • @user-mg2lf9mx7r
    @user-mg2lf9mx7r5 жыл бұрын

    Thanks a lot , you are one of the best teachers in the world of Excel!

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thank you so much for your kind words. Just trying to do my bit. Such appreciation by viewers is very encouraging. Will try to come up with more useful lessons.

  • @usama273
    @usama2737 жыл бұрын

    First time i saw the most easiest way to use IF formulas thats awesome

  • @Exceljunction

    @Exceljunction

    7 жыл бұрын

    Thanks for appreciating Moeez. Do subscribe the channel and share with your friends too. Best Regards

  • @soumyashreebiswal14
    @soumyashreebiswal145 жыл бұрын

    I actually got this question (the one uploaded as the PDF) as the annual project !! At first, i couldn't do it, but then for god's sake, I found out the source (this video) and so it made my life a hell easier...Easily explained, this was a gr8 vvideo....!!

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.

  • @KiranKumar-kc5tw
    @KiranKumar-kc5tw5 жыл бұрын

    Just going for an interview and had a look over it and now im clear about the functions. Thank you sooo much sir.

  • @SaiTeja0805

    @SaiTeja0805

    5 жыл бұрын

    Which company you are working?

  • @eleanorsummer8320
    @eleanorsummer83206 жыл бұрын

    This is explained in such a simple manner, thankyou so much.

  • @Exceljunction

    @Exceljunction

    6 жыл бұрын

    Thanks for appreciating.

  • @akinyetunpraise6742

    @akinyetunpraise6742

    5 жыл бұрын

    I'm in trouble with my table. I can't tell it here. How can i contact you

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Please post your query on our WhatsApp group www.exceljunction.com/whatsapp-group/

  • @iscoalmichael3117
    @iscoalmichael31175 жыл бұрын

    Thanks for the terrific job, it solves almost all of my daunting task.

  • @mudassarnadeem4084
    @mudassarnadeem40845 жыл бұрын

    Plese explain during putting any formula how can I understand where I putt Bracket & comm (," ") as i show on the comment Beause i don't know (where_ when_ what) I think You understand pleas upload detail video

  • @hussainabbas2024
    @hussainabbas20245 жыл бұрын

    perfect! I did not understand a thing when our teacher taught us. Thanks for video need more of them and subscribing you

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.

  • @tdm5927
    @tdm59276 жыл бұрын

    You did an excellent job explaining how each one works!! Love it!!

  • @Exceljunction

    @Exceljunction

    6 жыл бұрын

    +TT Matt Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.

  • @filiproh2625
    @filiproh26255 жыл бұрын

    Awesome! Easy and most importantly fast and all in one video!

  • @sarahc.1956
    @sarahc.19564 жыл бұрын

    Incredible. Learned so many functions in just one video. Delivery of the video was simple and informative. Thank you!

  • @Exceljunction

    @Exceljunction

    4 жыл бұрын

    Thanks for appreciating

  • @pensymorin5042
    @pensymorin50424 жыл бұрын

    Awesome! The best teacher in Excel ever lived in the planet earth! Thank you so much Teacher. I really understood everything from the beginning of the video til the end of it. Amazing! God Bless you more!!

  • @Exceljunction

    @Exceljunction

    4 жыл бұрын

    Thanks for the kind words. Glad, could be of help.

  • @Sjongleringsmannen
    @Sjongleringsmannen4 жыл бұрын

    Thank you for a nice tutorial in heavy used excel functions!

  • @stephanie03
    @stephanie035 жыл бұрын

    Thank you so much for this video! You must be a great teacher! 😊

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.

  • @kofibamfo6401
    @kofibamfo64014 жыл бұрын

    wow !. You really simplified it all for me. Thank You very much

  • @shewalemabedla8452
    @shewalemabedla84525 жыл бұрын

    Thank you so much for this video! you must be a great teacher!

  • @Exceljunction

    @Exceljunction

    4 жыл бұрын

    Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.

  • @roosterr66
    @roosterr664 жыл бұрын

    You are by far the best teacher I've come across. I was petrified of excel formulas and you made it look believable. Thank you

  • @Exceljunction

    @Exceljunction

    4 жыл бұрын

    Thanks for the kind words.

  • @happyfamilylifescreations
    @happyfamilylifescreations5 жыл бұрын

    Thank you so much for the understanding on the functions.will come back for more on excel..have an assessment to do

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Cheers

  • @09shirish
    @09shirish7 жыл бұрын

    thanks for your valuable guidance

  • @Exceljunction

    @Exceljunction

    7 жыл бұрын

    +Shirish Shelke Thanks for appreciating Shirish. Do subscribe the channel and share with your friends too. Best Regards

  • @muhammadyaqoob1869
    @muhammadyaqoob18694 жыл бұрын

    Best way of teaching

  • @javedaslam8274
    @javedaslam82745 жыл бұрын

    very nice way of explaing all necessary formulae in one excel file in a very shrt time..

  • @mhmedia6710
    @mhmedia67104 жыл бұрын

    Thank you for the wonderful lesson, I have learnt something

  • @nasirmuhammad3901
    @nasirmuhammad39014 жыл бұрын

    Thank you for this video which taught basic excel calculation in the most easiest way.

  • @Exceljunction

    @Exceljunction

    4 жыл бұрын

    Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.

  • @minnieescarilla8842
    @minnieescarilla88425 жыл бұрын

    You are a good teacher. Your speed in teaching is just perfect for me to follow and understand . You are the best !!! Keep it up Sir.

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.

  • @thegirlinquestion
    @thegirlinquestion5 жыл бұрын

    preparing for my interview tomorrow :^)

  • @wasimprince4353

    @wasimprince4353

    5 жыл бұрын

    You know i failed in interview bcz i have less knowledge in excel,have u got job

  • @PhanithReach
    @PhanithReach5 жыл бұрын

    Really nice to see your video. I have learn more now. Thanks so much. Really hope to get more useful functions from your video.

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.

  • @tonysalinas5903
    @tonysalinas59035 жыл бұрын

    This really helps, Thanks!

  • @raviwadhwa1815
    @raviwadhwa18153 жыл бұрын

    So effective example, with everything into it.

  • @ezizkarliyev2833
    @ezizkarliyev28336 жыл бұрын

    Thank you for this video!Explained very well and easily to understood :)

  • @Exceljunction

    @Exceljunction

    6 жыл бұрын

    +Eziz Karliyev thank you for appreciating. Please spread the good word. Do not forget to subscribe the channel for more useful stuff.

  • @shyamsundar-xw1vq

    @shyamsundar-xw1vq

    6 жыл бұрын

    you helps me lot,. thank u so much sir.

  • @johnd6575
    @johnd65756 жыл бұрын

    Formula's make excel a very powerful tool.

  • @Exceljunction

    @Exceljunction

    6 жыл бұрын

    +John D Yes, very much

  • @ezzahmed7080
    @ezzahmed70803 жыл бұрын

    Hello Sir, So precise! So clear! And to the point! Thank you for sharing. Bless you!

  • @Exceljunction

    @Exceljunction

    3 жыл бұрын

    Thanks for appreciating. Please do like the video and subscribe our channel for more such useful videos.

  • @lubyayicharles3305
    @lubyayicharles33054 жыл бұрын

    It has been a great lesson....Thanks so much

  • @ismailallychakachene652
    @ismailallychakachene6525 жыл бұрын

    Thank you very much , it is kind of you to help us understand excel basics properly

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.

  • @nabrii1924
    @nabrii19245 жыл бұрын

    Thank God for the video lectures, I have learnt a lot. I gained confidence in my excel studies.

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thanks for your kind comments. Much appreciated. We'll try to make more such useful videos. Do not forget to subscribe the channel.

  • @loganathanr238
    @loganathanr2385 жыл бұрын

    Amazing tutorial love this first tym i seen how to use these functions with more easily...

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thanks for appreciating. Please do subscribe our channel for more updates.

  • @SushmitNaik
    @SushmitNaik4 жыл бұрын

    Very informative! And peaceful voice 👍🙂

  • @reyaden6049
    @reyaden60495 жыл бұрын

    Im so bothered by F16 & F17. Can you explain?

  • @faithjeroben8786
    @faithjeroben87865 жыл бұрын

    well explained...…...thank you sir

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.

  • @SuneelKumar-de8yn
    @SuneelKumar-de8yn5 жыл бұрын

    I need 2,4,6,8...so on rows beside 1,3,5,7....is it posible

  • @georgerobingeorge
    @georgerobingeorge5 жыл бұрын

    HOW CAN WE CALCULATE THE SUM OF 2 COLUMNS WHICH WE NEED TO MULTIPLE THE ROW AND SUM OF COLUMN

  • @tastycuppa2851
    @tastycuppa28516 жыл бұрын

    Thank you so much It is very very simple method Thank you You did a brilliant job

  • @Exceljunction

    @Exceljunction

    6 жыл бұрын

    Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.

  • @aniki7232
    @aniki72326 жыл бұрын

    That was so much helpful for most of us.

  • @Exceljunction

    @Exceljunction

    6 жыл бұрын

    Glad you found it helpful. Please spread the good word. "Like" and "Subscribe" for more such useful videos.

  • @dcpssaiha5415
    @dcpssaiha54155 жыл бұрын

    Loved it...Thank you for posting...Your video is very helpful and easy to understand as well

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.

  • @patrickbaysahwala33
    @patrickbaysahwala333 жыл бұрын

    The formulas are a bit tricky but I'm gradually picking up, thanks very much.

  • @HeartlanderArt
    @HeartlanderArt4 жыл бұрын

    Very helpful. Thank you!

  • @pravinkarade2280
    @pravinkarade22806 жыл бұрын

    it nice and regular useful formulas so thnx sir........to bring essy it for us........

  • @Exceljunction

    @Exceljunction

    6 жыл бұрын

    Thanks for appreciating. Please "Like" and "Subscribe" for more such useful tutorials.

  • @nurasahardid4641
    @nurasahardid46413 жыл бұрын

    what if you have the total and you need to subtract others as you enter and the total column will zero at the end. please help

  • @karvintin09
    @karvintin094 жыл бұрын

    Very knowledgeable. Thank you.

  • @veronicafahnbulleh4323
    @veronicafahnbulleh43235 жыл бұрын

    Thanks very much I enjoyed it

  • @RajSiv
    @RajSiv4 жыл бұрын

    Thanks for your videos in simpler way to understand Excel function.. Please check with avgif and avgifs selection criteria..I didn't understand these two function

  • @Exceljunction

    @Exceljunction

    4 жыл бұрын

    Please do not forget to 'subscribe' to our channel for more such useful videos.

  • @thaimalabar5755
    @thaimalabar57554 жыл бұрын

    i want the main sheet full row come automatically in the other sheet as per the sheet name and the code of the customer.... so is it possible please advise

  • @secretaryalghurair8104
    @secretaryalghurair81046 жыл бұрын

    Thanks so much, this is the most easiest way to learn this formula that has being a problem to me. Thanks once again

  • @Exceljunction

    @Exceljunction

    6 жыл бұрын

    Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.

  • @Iksi_
    @Iksi_3 жыл бұрын

    You are the reason i will get a good grade on my excel test!

  • @Exceljunction

    @Exceljunction

    3 жыл бұрын

    Happy if we could be of any help. Wish you all the best for your test 👍

  • @mittujose2741
    @mittujose27413 жыл бұрын

    Very informative and easy to understand

  • @Andrew_Jordaan
    @Andrew_Jordaan6 жыл бұрын

    THANK YOU! YOU HELPED ME SOOOOO MUCH!

  • @Exceljunction

    @Exceljunction

    6 жыл бұрын

    Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.

  • @rasithdias1584
    @rasithdias15843 жыл бұрын

    absolute lifesaver g, thx

  • @vidyanair9432
    @vidyanair9432 Жыл бұрын

    Explained practically by applying each function . Well done Sir. Thanks.

  • @Exceljunction

    @Exceljunction

    Жыл бұрын

    You are welcome

  • @wihazet1185
    @wihazet11856 жыл бұрын

    Hi mate, could you please tell me, what is the name of the application that you are using to capture screen?

  • @uchenwogo2544
    @uchenwogo25445 жыл бұрын

    Thanks Sir, the video is simple and clear.

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.

  • @trustinwwjd1997
    @trustinwwjd19975 жыл бұрын

    Whoa,,,, thanks for sharing,,,, GOD bless for your all good works,,,,,

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.

  • @taniakhatun7642
    @taniakhatun76426 жыл бұрын

    I loved this it's awesome and most easy

  • @Exceljunction

    @Exceljunction

    6 жыл бұрын

    Great that you liked. Please have a look at other videos too in our channel. You may find them useful too. Do not forget to "subscribe".

  • @mohammednowfer8732
    @mohammednowfer87325 жыл бұрын

    Hi, the method of explaining is very fantastic can understand everyone....thank you for this video... very usefull..Thanks....

  • @Exceljunction

    @Exceljunction

    4 жыл бұрын

    Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.

  • @adenikeolatunde5333
    @adenikeolatunde53335 жыл бұрын

    Very helpful. Thanks a lot

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.

  • @Ayushgaming-bj1rl
    @Ayushgaming-bj1rl3 жыл бұрын

    Excellent sir you are great teacher in the worĺd

  • @fukiaatechnology9192
    @fukiaatechnology91924 жыл бұрын

    Excellent Sir. Thanks a lot.

  • @ketn0o416
    @ketn0o4164 жыл бұрын

    THANK YOU SO MUCHHHHHH!!!!!!

  • @leetwigg
    @leetwigg6 жыл бұрын

    Brilliantly explained. Thanks

  • @Exceljunction

    @Exceljunction

    6 жыл бұрын

    Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.

  • @deepab5259
    @deepab52595 жыл бұрын

    Thank you so much. It is simple and excellent.

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thank you for appreciating. It keeps us going. Cheers!!

  • @annantja1
    @annantja15 жыл бұрын

    best teacher

  • @aliyarhusain8276
    @aliyarhusain82766 жыл бұрын

    FANTASTIC SIR THANK YOU, SIR, IT WILL HELP ALL

  • @Exceljunction

    @Exceljunction

    6 жыл бұрын

    Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.

  • @terrencemadanhi8833
    @terrencemadanhi88335 жыл бұрын

    thanks for good explanation

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.

  • @lemoganginnocentia1542
    @lemoganginnocentia15424 жыл бұрын

    I know understand better. Thank you very much.

  • @nimrodsiluyele9676
    @nimrodsiluyele96765 жыл бұрын

    Good information for the beginners. very clear.

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.

  • @kelvyngonsalves8829
    @kelvyngonsalves88295 жыл бұрын

    Amazinggggggggggggggggggggg thanks

  • @ishaaggarwal4305
    @ishaaggarwal43053 жыл бұрын

    Which keyboard key do we need to press to select function from drop down after we write = and automatically suggestions pop up ?

  • @janral593
    @janral5935 жыл бұрын

    you are vary good teacher thanks so much

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thanks for appreciating. Please subscribe the channel for more such useful videos.

  • @skvish101
    @skvish1016 жыл бұрын

    I have a question, suppose I have a cell (A1) which changes its value every minutes, I want to find the minimum and maximum value of cell A1, every 15 minutes? what is the formula?

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Please post your query on our forum www.exceljunction.com/forum/

  • @cmavamsikrishna2173
    @cmavamsikrishna21732 жыл бұрын

    your explanation is very very ultimate. you explained in a very simple language and a lay man can also easily can understand.. became a big fan of you brother.. vamsi from india

  • @Exceljunction

    @Exceljunction

    Жыл бұрын

    Thank you so much for your kind comments 🙏

  • @srikanth7368
    @srikanth73684 жыл бұрын

    Sir, It is so educative. Thanks for sharing. I have a query, How to find the list of student names that scored more than 60marks...

  • @jackpanther1889
    @jackpanther18895 жыл бұрын

    Thanks for the great info

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thank you. Do not forget to subscribe our channel for more such useful videos.

  • @jeffersonumara2371
    @jeffersonumara23715 жыл бұрын

    this was super helpful

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thank you. Do not forget to subscribe our channel for more such useful videos.

  • @shero2794
    @shero2794 Жыл бұрын

    Thanks for teaching me this better that school

  • @Exceljunction

    @Exceljunction

    Жыл бұрын

    Happy to help

  • @syedarshadahmed4626
    @syedarshadahmed46263 жыл бұрын

    very helpful and clear. Thnks a ton!

  • @Exceljunction

    @Exceljunction

    3 жыл бұрын

    Thanks for appreciating.

  • @tajammulhussainKhadir
    @tajammulhussainKhadir6 жыл бұрын

    Very Nice tutorial, I learned something new from you. Hope you can clarify my doubt Can we count numof cel by filled colors? "Not by the by alphanumerical data".

  • @Exceljunction

    @Exceljunction

    6 жыл бұрын

    Please post your query on our forum. www.exceljunction.com/forum/

  • @shepal7306
    @shepal73062 жыл бұрын

    Excellent! Thank you so much.

  • @Exceljunction

    @Exceljunction

    Жыл бұрын

    You're very welcome!

  • @himendrapariyar1192
    @himendrapariyar11924 жыл бұрын

    I am not able to get the sum and average by simply dragging the cells downwards, is it because i am using the 2007 version?

  • @ru2285
    @ru22855 жыл бұрын

    this is sooooo good thanks

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thanks for appreciating. Please like and subscribe our channel for more useful updates.

  • @hardikchauhan8631
    @hardikchauhan86313 жыл бұрын

    Thank you sir it's help in my practical tomorrow

  • @Exceljunction

    @Exceljunction

    3 жыл бұрын

    Glad that it helped you. Do subscribe the channel for more such useful videos.

  • @arunthejeanious
    @arunthejeanious6 жыл бұрын

    Excellent ji...thank you so..much....

  • @Exceljunction

    @Exceljunction

    6 жыл бұрын

    +arunthejeanious Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.

  • @jerelnaito5975
    @jerelnaito59754 жыл бұрын

    Thank you!

  • @davindaniellaofficialtv7466
    @davindaniellaofficialtv74663 жыл бұрын

    Thanks it is useful nice sir..keep teaching

  • @ramajayam.e2348
    @ramajayam.e23485 жыл бұрын

    Thanks so very much Sir

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.

  • @user-ne1vl8vz1n
    @user-ne1vl8vz1n4 ай бұрын

    Thanks for the video

  • @giribv1691
    @giribv16916 жыл бұрын

    Thanks

  • @malindasandaruwanperera5505
    @malindasandaruwanperera55056 жыл бұрын

    I'm in trouble with my table. I can't tell it here. How can i contact you

  • @Exceljunction

    @Exceljunction

    6 жыл бұрын

    Please post your query on our WhatsApp group.

  • @sivasankarcommunications5971
    @sivasankarcommunications59715 жыл бұрын

    VERY GOOD... AND WELL EXPLAINED

  • @Exceljunction

    @Exceljunction

    5 жыл бұрын

    Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.

  • @krishnachaitanya5515
    @krishnachaitanya55153 жыл бұрын

    Simply super sir, thank you so much sir

  • @Exceljunction

    @Exceljunction

    3 жыл бұрын

    Thanks for appreciating.