Excel Basics 3: Count & Add with COUNT, COUNTA, SUM, COUNTIFS, SUMIFS Functions (Intro Excel #3)
ฝัง
- เผยแพร่เมื่อ 30 มิ.ย. 2024
- Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Start File: Download File: people.highline.edu/mgirvin/Y...
Download Excel Finished File: Download File: people.highline.edu/mgirvin/Y...
Download Full Written Notes: people.highline.edu/mgirvin/Y...
Class web page link: people.highline.edu/mgirvin/A...
Topics in this video:
1. (00:01) Introduction
2. (00:41) Different kinds of counting and adding
3. (02:28) Function Drop-down and screen tips to learn which function to use
4. (04:05) COUNT Function
5. (05:04) COUNTA Function
6. (06:16) SUM Function
7. (06:55) COUNTIFS Function
8. (10:14) Screen Click Trick to highlight an entire argument in a function.
9. (11:04) Be Careful of Spaces!!!!!
10. (11:48) SUMIFS Functions
11. (15:05) Use Ctrl Key to check your answers
12. (15:53) More Examples
13. (19:14) Homework you can do to practice
14. (20:06) Summary - Conclusion
![[LIVE] : ONE ลุมพินี 68 | คู่เอก "พระจันทร์ฉาย vs โจนาธาน"](http://i.ytimg.com/vi/F3IM3w-XchI/mqdefault.jpg)
@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: th-cam.com/video/XCR3ReuRnTk/w-d-xo.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!!!!
Love that your tutorials include homework. Thank you for taking the time to make these!
You are welcome, Christine!!!
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 : )
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!!!
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 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 : )
The way you expain is very clear sir and i just want to call you as "YOU ARE EXCEL IN EXCEL".
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!!!
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 : )
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!!!!
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.
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!!!!!
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 : ) : )
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!
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 : )
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.
I really learn a lot. No need for class sessions. Thanks for great job done.
You are welcome!
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 : )
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 : )
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 : )
I appreciate all the work you put into these, I look forward to learning everything I can through your videos.
You are welcome!
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 find it more fun listening to your voice, explanation are more simple then other people's. Thanks
The work you have done is a masterpiece and thank you so much for it.
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 : )
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 : )
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!!!!
One more great series ..Excel basics ..Love it. You are no doubt a great teacher. God bless you.
Thanks for your kind words, Sayyad : )
Loved the video & the homework. Thank you Professor Girvin.
You are welcome!
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!
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 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 TH-cam for free : )
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?
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 : )
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 : )
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 ❤
It's amazing that you are teaching all these in free🙏🙏🙏.
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 : )
Good day Sir! Your drive to impart your knowledge is commendable! God Bless you!
Glad to help, JESSIE!!!!
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'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 : )
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 : )
I wish the university I attend had professors like this guy.
Well, if they don't you can just come here to excelisfun at TH-cam : ) Glad, you like the videos, Jacob! Thanks for your support : )
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 : )
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 : )
Thank you so much ! So helpful and clear. And having exercises is even greater
You are welcome!
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 : )
Best video series on excel available on youtube, no doubt !
Glad you like it, AJEET : )
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: th-cam.com/play/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k.html
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 : )
by the way , i would like to specially thanking you for the idea of home work , really it helps
wishing that you proceed it in all H W files uploaded
You are welcome! There is no other free resource for learning Excel like this. Thanks for your consistent support on every video that you watch with your comments and thumbs up : ) : )
Best Tutorial I have ever seen, awesome. Thank You ExcellsFun.
You are welcome, Abdul!!!!!
Such good instruction! Thank you for helping us all understand Excel.
You are welcome! Thanks for the support with your comment, Thumbs Up and 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 : )
Thank you so much, sir. Your videos are truly amazing and very helpful.
You are welcome, Md. Soaib!!!!
Brilliant! as always. Love the presentation style - it really works for me.
Glad you like the videos, Adrian !!! Thanks for your support with your comments, Thumbs Ups and 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 : )
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 : )
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 : ) : )
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 : )
Another day another great Excel lesson. Thanks!
You are welcome, day after day, tacodelray!!!
thanks a lot i am learning so much, right now, your videos are soo easy to understand.
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 : )
Clear and concise information, excellently taught
Glad you like it!!!!
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 : )
You are the best of the best of the best !!!! Thank you so much!
Thank you so much for the assignments, looking forward to completing them.
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.
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 TH-cam 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!
Thank you Mike for another EXCELlent Video.
You are welcome! Thank you for your continual EXCELlent support : )
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 : ) : )
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
I hope I will learn Excel in just one week
Thanks a lot for efforts sir ☺️
You are welcome!
hey mike thanks for the video, have to review your last 2 to refresh what I learned. excellent video!
You are welcome for the video!! Yes, you can watch #1 and #2 to review : ) Thanks for your support, Alphaeus!!!
Excellent, very helpful. Thanks a lot, Professor Girvin
You are welcome a lot, Mohammad!! Thanks for your support with your comment, thumbs up and Sub : )
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.
Your the best Teacher out There thank you thank you thank you
You are welcome!!!!
I've recommended your channel to anyone that would listen!
Thanks for the support, Tosan : )
You are great excel teacher in world
Thanks a lot for such kind of efforts.keep it Up sir
You are welcome!!
Man, you are awesome. I am so so thankful to you. You cannot guess. ❤️❤️❤️😭
You are so welcome!!!!!
loving these videos...thank you so much
You are welcome so much!!!
You make Excel so easy. Thank you.
You are welcome! Thank you foe the support with your comment, Thumbs Up and Sub : )
Best Microsoft Office teacher ever!
Glad to help, John!!!
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 th-cam.com/video/45QYIUBVSMY/w-d-xo.html and th-cam.com/video/nvOr2wLj2MU/w-d-xo.html
Another excellent video!
thank you so much for the time you took to make these
You are welcome for the time and for the videos, Abed! Thank you for the support with your comment, Thumbs Up and Sub : )
Great video! LOVE the homework!!!!
Glad you like all the posted Excel items!!! Thank you for the support with your comment, Thumbs Up and Sub!!!!
You are the best. Thank you very much for this great video and information.
I am glad that the video helps! Thank you for the support with your comment, Thumbs Up and Sub : )
Video is 👍!! Love learning)) thx for homework 📚 very helpful
You are welcome! Thanks for your Support, _AnBu_!!!
Hi Professor, Hallelujah Enlightenments for Excel!
I am glad that the videos help! Thank you for your support : )
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!!!!
Enjoying, thank you so much.
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!!!!
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 : )
very precise presentation, I have learnt a lot in this video
Glad to help!!!!
Thank you very much 💯 really appreciate your efforts 😀
You are welcome, Sumit!!!
Superbly explained.
Yes! Glad you liked it, Kishorchandra!!!!!