@7:21 to see how to type Gigi in Sales Rep criteria cell and have row turn yellow? It is an advanced trick. I don't teach it till later in the sequence of classes. It requires mixed cell references, which we have not learned at this point in class. Here is a video about how to do it though: ruclips.net/video/XCR3ReuRnTk/видео.html
I've been accepted to an MBA program as a psychology undergraduate and these videos are a gift! I'm enjoying my time staring at spreadsheets with these instructions.
Yes indeed, I try to add something for everyone : ) Really, though, it is by telling a story about a topic that does not have any holes and is told in a logical order that means everyone can find something. The reason is because there are not many stories told about Excel Topics that don't have holes and which make no assumptions. Thanks for stopping by in the comments, James : )
I am transitioning careers at the present moment. Your videos with reference material is AWESOME! I now have the confidence to make me successful in my new career.
Thanks for a great introduction to count(ifs) and sum(ifs) - it's also great you included COUNTA. When I give training sessions, everyone knows COUNT but many don't know about COUNTA.
Not only am I having an absolute blast with these videos, but after this one I have been shown everything I expected to learn. I can’t wait to see what else is in store! Thanks for your videos!
The influence of teachers extends beyond the classroom, well into the future. - F. Sionil Jose Forever indebted to you sir, you bring out the best in everyone. Thank you is never enough.
You do not know how grateful I am to follow your classes, I have learned a lot. I love Excel Is Fun. I am one of yours followers since 2013. God Bless you.
Top notch tutorials. For some reason you have the ability to teach me about excel whilst also entertaining me. Great teaching process and you really break down everything in detail so I can understand fully. Thanks Michael.
Thank you again. Made this screen name when I was like 17. If you had told 17 year old me that when I'm 29 I'd be at home enjoying Excel homework problems he wouldn't have believed you. I'm enjoying the lessons
@@excelisfun Someone has had to have pointed this out by now but in HW(2) I believe there is a typo. Instructions say that in F6 we should count how many words there are in the B4:B12 range but I think it's supposed to be G5 that we make that formula
The idea of giving Home Work. was an excellent way of making the learning experience more interactive. Thank you so much for putting your time and effort in creating awesome content.
My boss referred me to your channel. Excellent content. Thank you for making it available for free to all. PS. My boss is an excel expert and his recommending your channel above all else speaks volume. Thank you
Oh my god!!!....I just love you my RESPECTED SIR.... wish I had found you years back...but I have you now :) , so with so much of admiration & respect from a very small town in India, my good Sir ..
You are welcome, Apples Oranges!!! I am glad that the content that I post helps you in a small town in India : ) You can help me too with a comment and thumbs up on every video that you learn from, and of course a Sub too : ) P.S. Love the user name: Apples Oranges : )
I was watching other videos on youtube about excel, and I did not like them. I thought it was boring and only did it as I wanted to take advantage of the range of opportunity excel gives to people who understand it. I was on Reddit and a lot of people said: "go check out Excelisfun". You even have homework??? Thank you so much, I am actually enjoying excel! Who would have known? I am liking all the videos I am watching, you deserve a lot of recognition.
I am very grateful for you making this videos. I had gone for an interview but I did not do well in using excel but It definitely opened an opportunity to learn from you. May the Almighty God bless you
You are welcome, Joseph! I am glad that the videos that i make can help you to become better for your future job interviews. Thanks for your support of my efforts to bring free education to the world with your comments and thumbs ups on each video that you learn from, and of course your Sub : )
@@excelisfun my friend do you have play list for new beginner what start learning the function do you play list plz help me out also do Facebook link can follow you thank you changed my life in excel
@@saeedtheman This Excel Basics class is my beginner class. Functions are only a small part of Excel. So in this Excel Basics class, I teach all of Excel, including functions. I do not have an Excel Facebook site, but here is the full Excel Basics RUclips class: ruclips.net/p/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k
You are welcome, Lewis!!! I started posting videos 12 years ago to do exactly that: help people learn Excel so they can get the job, and then be so efficient with Excel that they have extra time for vacation : )
Sir, Your every video is more than excellent. I am so confident that there is no other advanced tutorial and trainer like you. I am not interested to follow any other trainer's tutorial if you have tutorial in which I am interested to learn. If it is possible, I will give a lot of Thumbs Up in every of your videos. We need trainer like you to make the world more better. I usually suggest to download and follow your videos whoever want to learn excel meeting with me. Thanks a lot to keep love and patience in your teaching field.
Michael Girvin, Your amazing on the training Excel platform, I love your videos, they are very clear and understandable, thanks for all your support and help, appreciated,
Dear Mike, I think you are the best of the best excel teacher on the entire youtube. I give tremendous credits to your free PDF textbook and the exercise to practice on, those really make your tutorials outstanding! Appreciate it!
You are welcome, Lyman! It is my way of trying to make the world a better place! Thanks for the support on each video with a comment, Thumbs Up and a Sub : )
@@excelisfun If each viewer could only recommend one excel tutor on youtube, then I'd definitely present you. Anyone could benefit so much by going thru your videos step by step. I will keep learning from them. Two thumbs-up!
Thanks so much Mr./Professor Girvin! I am so glad I found your tutorials! I feel so much more competent with Office! I have given a thumbs up to every video lol!
It's just OMG when i saw the title of the video i said these functions are known to me but when i insisted to see the video i learned that they can do more and more so impressive thank you Mr. Mike
Love your videos. Using them to help train before my job! One question though: How did you do that highlighting function in the Rep Criteria and Date criteria so that is highlights the names and dates when put into B1 and B2 respectively?
Excellent videos, all the steps are clearly explained, thank you so much for making them available free of cost to everybody. Learning a lot through them.
Great - Practice makes perfect. Really, that is one of the things that makes excelsifun channel at RUclips THE place for free education: you get it all: video, Excel files, free chapter from the book (pdf) and practice problems with solutions : ) Thank you for your support, Miles : )
ExcelIsFun your enthusiasm for teaching shown throughout the video is inspiring, and your teaching method where you highlight important details through your slowed way of speaking showcases your tutoring expertise. I'm grateful for you making all of these resources available for free. Looking forward to the next video!
You are welcome, TSV E! Glad you love the material that I post : ) Thank you for helping me with your comments and thumbs up on each video that you learn from, and of course your Sub : )
Definitely learning a lot from these introductory videos. I have Linkedin Learning but the instructors are pretty "dry." Had to give up and come here. I have to admit I'm learning a LOT more, easily and rapidly. The keyboard shortcuts are great and the way the instructor explains things is great, which is useful for an incredibly boring topic like Excel. You make it seem fun and that's saying a lot.
You are welcome! That is great that they help with your job!! You can help me too, by always clicking that Thumbs Up and leaving a small comment - it really helps to support : )
In the beginning I really like to thank you very much. You are the reason for the proficiency of the program and learning many, many, and secondly, I would like to re-create the video industry but in Arabic so as to expand the base of the beneficiaries due to the weakness of Arabic content.
my notes from this video for if others want to use it: count formulas: count = counts all numbers countA = count all cells NOT empty countIF(s) = count num of cells specified by the given set of conditions or criteria example: =COUNTIFS(B5:B13, "Gigi"). this counts how many times Gigi appears in this range of cells. sum formulas: sumIF(s) = sum of numbers based on criteria. ' example: =SUMIFS(C5:C13, B5:B13, "Gigi"). this counts the sum of numbers (C5:C13), based on IF Gigi appears in this range of cells (B5:B13) do this to double check some numbers, that are not easy to do quick mental math for: select all the cells you want to check, and look at the bottom right of excel. it should display "average", "count", and "sum" check and complete the homework problems to solidify concepts and tools
EXCELlent!!! Glad the video and Homework help !!! Don't forget that part of the Homework is to comment and Thumbs Up on each video, then it is REALLY perfect : )
As always, and excellent vid. I would just suggest you show that the criteria for countifs() goes beyond simply "=." You can do > and < and combine them.
@7:21 to see how to type Gigi in Sales Rep criteria cell and have row turn yellow? It is an advanced trick. I don't teach it till later in the sequence of classes. It requires mixed cell references, which we have not learned at this point in class. Here is a video about how to do it though: ruclips.net/video/XCR3ReuRnTk/видео.html
Thsnk so much for coming back and telling this. Really apprecite it.
@@mokisan You are so welcome, HT!!!!
hi, where is the video?
I've been accepted to an MBA program as a psychology undergraduate and these videos are a gift! I'm enjoying my time staring at spreadsheets with these instructions.
Awesome!!!!
Whether you are a beginner or an expert you will hear something you didn't know in these videos. Thank you!
Yes indeed, I try to add something for everyone : ) Really, though, it is by telling a story about a topic that does not have any holes and is told in a logical order that means everyone can find something. The reason is because there are not many stories told about Excel Topics that don't have holes and which make no assumptions. Thanks for stopping by in the comments, James : )
so nice concepts of each count and sum and sumif and countifs etc no any one like you guru of excel world...
Yes sir! I am happy to help you learn the beauty and power of Excel : ) : )
I never thought learning how to use Excel can be so entertaining! You are the best example of a teacher who knows how to make learning fun. Thank you.
You are welcome for the fun and learning, Orsolya!!!! Thanks for your support with your comment, Thumbs Up and Sub : )
You're a blessing to the World sir 🌍, with your help, i can now operate Excel a little ❤️
Glad to help!!!
The way you expain is very clear sir and i just want to call you as "YOU ARE EXCEL IN EXCEL".
Just started following your channel and it's really amazing. Learnt alot on Just 3 lessons. Keep up the amazing work
Glad you like the work, It will keep coming!!!
Finally 🎉 I'm so proud of myself 🙌.I did my assignment and I can say that I'm learning from the very very best❤.
I am proud of you too!!!!
I really learn a lot. No need for class sessions. Thanks for great job done.
You are welcome!
I am transitioning careers at the present moment. Your videos with reference material is AWESOME! I now have the confidence to make me successful in my new career.
Glad to help, Nia!!!! You can help me with your thumbs up and comment on each video that you learn from : )
Love the pace of your explanations! TY
You are welcome!!!
These tutorials are the first thing I watch every morning with my coffee lol thank you for making these videos, very entertaining and informative!
Glad to help with the morning coffee!!!
Love that your tutorials include homework. Thank you for taking the time to make these!
You are welcome, Christine!!!
Your videos are sublime. I just chanced upon them and have learned so much! You are a master excel teacher.
Thank you for the kind words!!! Thanks also for the support with your comment, Thumbs Up and Sub : )
Thanks for a great introduction to count(ifs) and sum(ifs) - it's also great you included COUNTA. When I give training sessions, everyone knows COUNT but many don't know about COUNTA.
Yes, I so agree!! On many Statistic projects where we get survey data I use COUNTA much more often than COUNT!!!
Not only am I having an absolute blast with these videos, but after this one I have been shown everything I expected to learn. I can’t wait to see what else is in store! Thanks for your videos!
The is the beauty of Excel: A blast is always had, because there is nothing Excel can't help you do in a fun and efficient way : )
The influence of teachers extends beyond the classroom, well into the future.
- F. Sionil Jose
Forever indebted to you sir, you bring out the best in everyone. Thank you is never enough.
Just watched Videos 1 through 3. your Videos are AMAZING!!! thank you so much!
Glad the videos help!!!!!
You do not know how grateful I am to follow your classes, I have learned a lot. I love Excel Is Fun. I am one of yours followers since 2013. God Bless you.
Top notch tutorials. For some reason you have the ability to teach me about excel whilst also entertaining me.
Great teaching process and you really break down everything in detail so I can understand fully.
Thanks Michael.
You are welcome, Jamie! Thank you for your kind words : ) : ) Thanks also for the support with your comment, Thumbs Up and Sub!
You are a simply an excel Guru. I have quite a basic knowledge when it comes to excel. However, you made it so simple. Thank you.
This videos are amazing. I'm learning Excel because I want to work in a Tech company. Kudos 🎉
Glad the videos and files can help!!!!
It's amazing that you are teaching all these in free🙏🙏🙏.
Best video series on excel available on youtube, no doubt !
Glad you like it, AJEET : )
Best Microsoft Office teacher ever!
Glad to help, John!!!
Your the best Teacher out There thank you thank you thank you
You are welcome!!!!
Thank you so much for the assignments, looking forward to completing them.
You are welcome!!!
Thank you again. Made this screen name when I was like 17. If you had told 17 year old me that when I'm 29 I'd be at home enjoying Excel homework problems he wouldn't have believed you. I'm enjoying the lessons
That is what happens to us when we get older and wiser : ) Excel can REALLY make our life easy : )
@@excelisfun Someone has had to have pointed this out by now but in HW(2) I believe there is a typo. Instructions say that in F6 we should count how many words there are in the B4:B12 range but I think it's supposed to be G5 that we make that formula
@@sittingpsyduck4583 Fixed. Thanks for helping me to edit. This will help the rest of the Team : ) : )
Wow man I am gonna admit no body teach like this, thank you brother for such teaching, its really hard to do what you do ❤
I find it more fun listening to your voice, explanation are more simple then other people's. Thanks
Ur way of explanation will make the person to understand, instate of learning..👍
I am glad you are understanding! Thank you foe the support with your comment, Thumbs Up and Sub : )
The idea of giving Home Work. was an excellent way of making the learning experience more interactive. Thank you so much for putting your time and effort in creating awesome content.
Glad all of what I post helps you, Aakash!!! homrworkisfun, right?
More than Fabulous. you are the world champion of Excel professor.
Thank you for the kind words, AbuOmar!!! Thanks for the support with your comment, Thumbs Up and Sub : )
My boss referred me to your channel. Excellent content. Thank you for making it available for free to all. PS. My boss is an excel expert and his recommending your channel above all else speaks volume. Thank you
You are welcome, Stacey! Thanks for helping to support this free resource with your comments, Thumbs Ups and Sub : ) Tell your boss I say hi!
Oh my god!!!....I just love you my RESPECTED SIR.... wish I had found you years back...but I have you now :) , so with so much of admiration & respect from a very small town in India, my good Sir ..
You are welcome, Apples Oranges!!! I am glad that the content that I post helps you in a small town in India : ) You can help me too with a comment and thumbs up on every video that you learn from, and of course a Sub too : ) P.S. Love the user name: Apples Oranges : )
@@excelisfun of course...anything for you Sir ..
@@applesoranges559 : ) : )
I wish the university I attend had professors like this guy.
Well, if they don't you can just come here to excelisfun at RUclips : ) Glad, you like the videos, Jacob! Thanks for your support : )
I appreciate all the work you put into these, I look forward to learning everything I can through your videos.
You are welcome!
Loved the video & the homework. Thank you Professor Girvin.
You are welcome!
I was watching other videos on youtube about excel, and I did not like them. I thought it was boring and only did it as I wanted to take advantage of the range of opportunity excel gives to people who understand it. I was on Reddit and a lot of people said: "go check out Excelisfun". You even have homework??? Thank you so much, I am actually enjoying excel! Who would have known? I am liking all the videos I am watching, you deserve a lot of recognition.
Clear and concise information, excellently taught
Glad you like it!!!!
I am very grateful for you making this videos. I had gone for an interview but I did not do well in using excel but It definitely opened an opportunity to learn from you. May the Almighty God bless you
You are welcome, Joseph! I am glad that the videos that i make can help you to become better for your future job interviews. Thanks for your support of my efforts to bring free education to the world with your comments and thumbs ups on each video that you learn from, and of course your Sub : )
Manifesting that I will become a data analyst. I am applying tomorrow, I hope I'll get a job!! Thank you so much. I learned a lot from you!
You are welcome! Good luck : )
I wish if I know you in person and take some class.... Really a teacher knows how to teach and explains. Just brilliant.
Well even though you are not in my class live, you get it here at RUclips for free : )
You are real Gem in this world. excellent video, to the point, full of knowledge and clear presentation.
Glad you like the video thanks for your kind words : )
You are Great!! How wish I could have found your lectures earlier! Thank you very much!!
You are welcome! If you do all 25 vids, you can be an Excel Master. Here is full playlist: ruclips.net/p/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k
Good day Sir! Your drive to impart your knowledge is commendable! God Bless you!
Glad to help, JESSIE!!!!
I hope I will learn Excel in just one week
Thanks a lot for efforts sir ☺️
You are welcome!
the best youtube for excel this man deserve a prize
My prize has always been simple: thumbs ups and comments from viewers like you : )
@@excelisfun your the only person I met that is thia good
@@saeedtheman Just having fun with Excel - just like you are having now, bob : )
@@excelisfun my friend do you have play list for new beginner what start learning the function do you play list plz help me out also do Facebook link can follow you thank you changed my life in excel
@@saeedtheman This Excel Basics class is my beginner class. Functions are only a small part of Excel. So in this Excel Basics class, I teach all of Excel, including functions. I do not have an Excel Facebook site, but here is the full Excel Basics RUclips class: ruclips.net/p/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k
I might be selected to work in a local office in my city. These videos have been so valuable in practicing excel. Thank you again.
You are welcome, Lewis!!! I started posting videos 12 years ago to do exactly that: help people learn Excel so they can get the job, and then be so efficient with Excel that they have extra time for vacation : )
One more great series ..Excel basics ..Love it. You are no doubt a great teacher. God bless you.
Thanks for your kind words, Sayyad : )
Superbly explained.
Yes! Glad you liked it, Kishorchandra!!!!!
thank goodness he's in a teaching position. he's born to teach!
I hope the video helped, iiovelouisDTV
Glad you liked the video, LLovelouisDTV!!!!
Sir,
Your every video is more than excellent. I am so confident that there is no other advanced tutorial and trainer like you. I am not interested to follow any other trainer's tutorial if you have tutorial in which I am interested to learn. If it is possible, I will give a lot of Thumbs Up in every of your videos. We need trainer like you to make the world more better. I usually suggest to download and follow your videos whoever want to learn excel meeting with me. Thanks a lot to keep love and patience in your teaching field.
I am so glad that the teaching helps! Thank you for your support : )
I've recommended your channel to anyone that would listen!
Thanks for the support, Tosan : )
Michael Girvin, Your amazing on the training Excel platform, I love your videos, they are very clear and understandable, thanks for all your support and help, appreciated,
You are welcome, kelvin!!!!
the homework segment was so helpful!
Glad that my posted materials help you, Hans Elma!!
Dear Mike, I think you are the best of the best excel teacher on the entire youtube. I give tremendous credits to your free PDF textbook and the exercise to practice on, those really make your tutorials outstanding! Appreciate it!
You are welcome, Lyman! It is my way of trying to make the world a better place! Thanks for the support on each video with a comment, Thumbs Up and a Sub : )
@@excelisfun If each viewer could only recommend one excel tutor on youtube, then I'd definitely present you. Anyone could benefit so much by going thru your videos step by step. I will keep learning from them. Two thumbs-up!
@@XiongSir Thanks for the Two Thumbs Up : ) And thanks for your support!!!!
Thanks so much Mr./Professor Girvin! I am so glad I found your tutorials! I feel so much more competent with Office! I have given a thumbs up to every video lol!
Glad that help to build competence!!! Thank you for your support on each video : ) : )
It's just OMG when i saw the title of the video i said these functions are known to me but when i insisted to see the video i learned that they can do more and more so impressive thank you Mr. Mike
You are welcome - I am glad that the video helped you to learn some new things : )
Thank u
Professor Girvin you are the best, thanks a million sir. God bless man
You are welcome a million times!! Thank you for the support with your comment, Thumbs Up and Sub : )
I loved this lesson! The functions all seem incredibly useful and the homework was a great way to put what we've been learning into practice.
Homework makes us awesome : )
Sir you are officially the Excel guru, thumbs up to your knowledge and passion to share. God bless you.
Glad you like the videos! Thank you so much for your support : )
Love your videos. Using them to help train before my job! One question though: How did you do that highlighting function in the Rep Criteria and Date criteria so that is highlights the names and dates when put into B1 and B2 respectively?
This is the video where he had it coved ruclips.net/video/45QYIUBVSMY/видео.html and ruclips.net/video/nvOr2wLj2MU/видео.html
Thank you so much ! So helpful and clear. And having exercises is even greater
You are welcome!
Excellent videos, all the steps are clearly explained, thank you so much for making them available free of cost to everybody. Learning a lot through them.
You are welcome! I am glad the material is clear. Thanks for your support with your comment, Thumbs Up and Sub : )
Man, you are awesome. I am so so thankful to you. You cannot guess. ❤️❤️❤️😭
You are so welcome!!!!!
Your videos are so much fun to watch and so detailed. Than you do much for sharing!
You are welcome, Tom Jun! Glad that help are fun for you : )
Best Tutorial I have ever seen, awesome. Thank You ExcellsFun.
You are welcome, Abdul!!!!!
The homework was a lovely addition to the video! Looking forward to the next tutorial!
Great - Practice makes perfect. Really, that is one of the things that makes excelsifun channel at RUclips THE place for free education: you get it all: video, Excel files, free chapter from the book (pdf) and practice problems with solutions : ) Thank you for your support, Miles : )
ExcelIsFun your enthusiasm for teaching shown throughout the video is inspiring, and your teaching method where you highlight important details through your slowed way of speaking showcases your tutoring expertise. I'm grateful for you making all of these resources available for free. Looking forward to the next video!
I am glad that it all works for you : ) Thanks for your kind words!
You are great excel teacher in world
Thanks a lot for such kind of efforts.keep it Up sir
You are welcome!!
This is an amazing course. Thank you so much for taking the time to put it together.
You are so welcome for the course, Big Haole!!!! Thanks for the support with your comment, thumbs up and of course your Sub : )
Love everything about the way you explain things! Your great tutorials are so helpful and appreciated! THANK YOU SIR!
You are welcome, TSV E! Glad you love the material that I post : ) Thank you for helping me with your comments and thumbs up on each video that you learn from, and of course your Sub : )
Thanks its the best tutorials I've seen on Excel and a pleasure to learn spreadsheet.
You are welcome, Danie! Thanks for your support with your comment, thumbs up and of course your Sub : )
Definitely learning a lot from these introductory videos. I have Linkedin Learning but the instructors are pretty "dry." Had to give up and come here. I have to admit I'm learning a LOT more, easily and rapidly. The keyboard shortcuts are great and the way the instructor explains things is great, which is useful for an incredibly boring topic like Excel. You make it seem fun and that's saying a lot.
Another day another great Excel lesson. Thanks!
You are welcome, day after day, tacodelray!!!
Thank you so much, sir. Your videos are truly amazing and very helpful.
You are welcome, Md. Soaib!!!!
This is a well deserved, super positive comment section!
Glad you like the video, Wright's Right!!!!
Iam a Person admiring your work from india. 💓💓💓
Glad you like the work and it helps, saiteja!!!! Thanks for your support on each video with your comments and thumbs ups, and of course your Sub : )
Excellent, very helpful. Thanks a lot, Professor Girvin for making it available free.
You are welcome! Thank you for the support with your comment, Thumbs Up and Sub : )
You make Excel sooooo easy. Thank you so much for the tutorials, they are helping me a lot in my new job.
You are welcome! That is great that they help with your job!! You can help me too, by always clicking that Thumbs Up and leaving a small comment - it really helps to support : )
Amazing Video.Thanks a lot. Can't describe how grateful I am.
You are welcome, Anushervon!!!! Thanks for your support on each video that you watch with your comments, Thumbs Up and a Sub : )
Thank you Mike for another EXCELlent Video.
You are welcome! Thank you for your continual EXCELlent support : )
Thank you very much 💯 really appreciate your efforts 😀
You are welcome, Sumit!!!
very helpful and informative
Glad it helps!!!!
Your videos are very helpful. Thank you so much for all the efforts that you've put in all of your EXCeLlent videos!
You are welcome for the Excellent efforts, Jill Si! Thanks for your support with your comments, thumbs up and Sub : )
loving these videos...thank you so much
You are welcome so much!!!
In the beginning I really like to thank you very much. You are the reason for the proficiency of the program and learning many, many, and secondly, I would like to re-create the video industry but in Arabic so as to expand the base of the beneficiaries due to the weakness of Arabic content.
You can use my content for educational purposes! That will help to make the world a better place : )
I am really thankful to you as one who makes the world better
Go Team!!!!!! Please let me know when you start posting videos, I can't wait to Thumbs Up and comment on each of your videos : )
I just Subed your channel - I can't wait for your videos : )
You make Excel so easy. Thank you.
You are welcome! Thank you foe the support with your comment, Thumbs Up and Sub : )
very precise presentation, I have learnt a lot in this video
Glad to help!!!!
Forget to like and comment on this video, Came back from Lesson4 to like and comment and say thank you, Sir!
Much appreciated! : ) : ) : )
my notes from this video for if others want to use it:
count formulas:
count = counts all numbers
countA = count all cells NOT empty
countIF(s) = count num of cells specified by the given set of conditions or criteria
example: =COUNTIFS(B5:B13, "Gigi"). this counts how many times Gigi appears in this range of cells.
sum formulas:
sumIF(s) = sum of numbers based on criteria. '
example: =SUMIFS(C5:C13, B5:B13, "Gigi"). this counts the sum of numbers (C5:C13), based on IF Gigi appears in this range of cells (B5:B13)
do this to double check some numbers, that are not easy to do quick mental math for:
select all the cells you want to check, and look at the bottom right of excel. it should display "average", "count", and "sum"
check and complete the homework problems to solidify concepts and tools
Excellent again, and thanks for the homework in particular. Practice makes perfect!
EXCELlent!!! Glad the video and Homework help !!! Don't forget that part of the Homework is to comment and Thumbs Up on each video, then it is REALLY perfect : )
As always, and excellent vid. I would just suggest you show that the criteria for countifs() goes beyond simply "=." You can do > and < and combine them.
thanks a lot i am learning so much, right now, your videos are soo easy to understand.
The work you have done is a masterpiece and thank you so much for it.
You're such an awesome teacher, I'm so glad i found your channel! Thank you very much
You are welcome very much, Nathalia!!!! Thanks for the support with your comment, thumbs up and of course your Sub : )
Thank you very much ❤
Hi Professor, Hallelujah Enlightenments for Excel!
I am glad that the videos help! Thank you for your support : )
Many thx wishing you all the best
You are welcome, ahmed! Thanks for your support with your comment, thumbs up and your Sub : )