Excel Basics 3: Count & Add with COUNT, COUNTA, SUM, COUNTIFS, SUMIFS Functions (Intro Excel #3) 

@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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-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.

Finally 🎉 I'm so proud of myself 🙌.I did my assignment and I can say that I'm learning from the very very best❤.

Whether you are a beginner or an expert you will hear something you didn't know in these videos. Thank you!

so nice concepts of each count and sum and sumif and countifs etc no any one like you guru of excel world...

Love that your tutorials include homework. Thank you for taking the time to make these!

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.

These tutorials are the first thing I watch every morning with my coffee lol thank you for making these videos, very entertaining and informative!

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.

Just watched Videos 1 through 3. your Videos are AMAZING!!! thank you so much!

The way you expain is very clear sir and i just want to call you as "YOU ARE EXCEL IN EXCEL".

I really learn a lot. No need for class sessions. Thanks for great job done.

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

Love the pace of your explanations! TY

Your videos are sublime. I just chanced upon them and have learned so much! You are a master excel teacher.

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.

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.

You're a blessing to the World sir 🌍, with your help, i can now operate Excel a little ❤️

Loved the video & the homework. Thank you Professor Girvin.

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 a simply an excel Guru. I have quite a basic knowledge when it comes to excel. However, you made it so simple. Thank you.

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.

Ur way of explanation will make the person to understand, instate of learning..👍

You are Great!! How wish I could have found your lectures earlier! Thank you very much!!

Clear and concise information, excellently taught

Best video series on excel available on youtube, no doubt !

I wish if I know you in person and take some class.... Really a teacher knows how to teach and explains. Just brilliant.

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!

More than Fabulous. you are the world champion of Excel professor.

This videos are amazing. I'm learning Excel because I want to work in a Tech company. Kudos 🎉

I wish the university I attend had professors like this guy.

Thank you so much, sir. Your videos are truly amazing and very helpful.

It's amazing that you are teaching all these in free🙏🙏🙏.

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!

I appreciate all the work you put into these, I look forward to learning everything I can through your videos.

Your the best Teacher out There thank you thank you thank you

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

Good day Sir! Your drive to impart your knowledge is commendable! God Bless you!

You are real Gem in this world. excellent video, to the point, full of knowledge and clear presentation.

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 ❤

Thank you so much ! So helpful and clear. And having exercises is even greater

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.

Best Microsoft Office teacher ever!

I find it more fun listening to your voice, explanation are more simple then other people's. Thanks

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

Best Tutorial I have ever seen, awesome. Thank You ExcellsFun.

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!

Your videos are so much fun to watch and so detailed. Than you do much for sharing!

Another day another great Excel lesson. Thanks!

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 ..

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.

One more great series ..Excel basics ..Love it. You are no doubt a great teacher. God bless you.

Thank you so much for the assignments, looking forward to completing them.

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,

Amazing Video.Thanks a lot. Can't describe how grateful I am.

the best youtube for excel this man deserve a prize

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.

thank goodness he's in a teaching position. he's born to teach!

Professor Girvin you are the best, thanks a million sir. God bless man

I hope I will learn Excel in just one week Thanks a lot for efforts sir ☺️

Excellent, very helpful. Thanks a lot, Professor Girvin for making it available free.

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.

Love everything about the way you explain things! Your great tutorials are so helpful and appreciated! THANK YOU SIR!

The homework was a lovely addition to the video! Looking forward to the next tutorial!

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.

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

Thanks its the best tutorials I've seen on Excel and a pleasure to learn spreadsheet.

Sir you are officially the Excel guru, thumbs up to your knowledge and passion to share. God bless you.

Man, you are awesome. I am so so thankful to you. You cannot guess. ❤️❤️❤️😭

Thank you Mike for another EXCELlent Video.

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!

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.

Excellent, very helpful. Thanks a lot, Professor Girvin

You are great excel teacher in world Thanks a lot for such kind of efforts.keep it Up sir

Superbly explained.

This is an amazing course. Thank you so much for taking the time to put it together.

You make Excel sooooo easy. Thank you so much for the tutorials, they are helping me a lot in my new job.

the homework segment was so helpful!

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.

I've recommended your channel to anyone that would listen!

Your videos are very helpful. Thank you so much for all the efforts that you've put in all of your EXCeLlent videos!

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.

This is a well deserved, super positive comment section!

Excellent again, and thanks for the homework in particular. Practice makes perfect!

thanks a lot i am learning so much, right now, your videos are soo easy to understand.

very precise presentation, I have learnt a lot in this video

The work you have done is a masterpiece and thank you so much for it.

You make Excel so easy. Thank you.

thank you so much for the time you took to make these

Such good instruction! Thank you for helping us all understand Excel.

Sir, Can I skip certain lessons if I am not well versed in certain areas? I am asking you because I found the beginning of the second lesson to be difficult as I do not do financial reports. I appreciate any guidance. Thank you.

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.

Hi Professor, Hallelujah Enlightenments for Excel!

Forget to like and comment on this video, Came back from Lesson4 to like and comment and say thank you, Sir!

For the formula in G11, when I hit ctrl + enter, it doesn't automatically add the currency format. I get 1100, instead of $1,100. Did I miss a step?

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

Thank you very much 💯 really appreciate your efforts 😀

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?

Many thx wishing you all the best

Another excellent video!