How to use COUNTIF and COUNTIFS in Microsoft Excel

Рет қаралды 825,278

4 жыл бұрын

Learn how to use COUNTIF and COUNTIFS to count the number of cells that meet a criterion or multiple conditions; for example, to count the number of times a particular city appears in a customer list.
In this video, I run through the following:
1) Count how many times a certain string or number appear in a list
2) Count how many times multiple items appear in a list
3) Count how many items are greater than or less than a certain value
4) Count how many items are between certain values
5) Count how many items do not match certain values
6) Count how many items begin or end with certain characters
7) Count how many items match certain conditions across multiple columns
Lastly, I cover how to use Excel for free on the web. Excel on the web supports the COUNTIF and COUNTIFS functions.
Here's the sheet I used if you want to follow along:
1drv.ms/x/s!AmxrofZZlZ-whId2V...
Watch more Excel tutorial videos: • ❎ How to use Excel
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
As full-disclosure, I work at Microsoft as a full-time employee.

Пікірлер: 299

@KevinStratvert 3 жыл бұрын

🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: kzfaq.info/sun/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

@nbjamspice 3 жыл бұрын

Kevin, thanks for the post but the link opens into the list of your how to for PowerPoint. Can you post the correct link to the Excel videos?

@bernarditu 3 жыл бұрын

I`d like to see your list of Excel videos as that`s what I`m learning at the moment, thanks (11/01/2021)

@nbjamspice 3 жыл бұрын

Kevin, please post the correct link to your list of Excel videos.

@KevinStratvert 3 жыл бұрын

Sorry about that! I’ve updated the link.

@nbjamspice 3 жыл бұрын

Your'e the best❤...your videos are my go to for everything I need. Thanks so much!

@kristineamnahazlewood2636 2 жыл бұрын

This has been the most easy to understand COUNTIF/S tutorial for BEGINNERS like me. Very helpful, thanks!

@noyondas6925 Ай бұрын

You're the best because 'when you teach something you cover each and every aspects of the topic'. Thank you ever so much

@danieldesio8149 2 жыл бұрын

I spent hours trying to figure out how to get a formula like this to work for the data I was trying to organize and this was the magic video that stopped my search. THANK YOU!

@xxandyxx569 3 жыл бұрын

Man, you just saved my week, didn't know about that ">"& to reference a cell.

@cynthiawoodall3598 2 жыл бұрын

Kevin, this video helped me so much with a project that I'm doing right now. No one else could help me with the count question! Thanks so much!!!

@riotjohnson889 Жыл бұрын

I really really hope Microsoft was paying you extra for these videos bc I know a lot more people are using excel bc of you. Everyone in my office watches your videos from old to young either to brush up or to learn something new. As always, thank you for your videos Kevin and not just for Microsoft products but all the programs/system you teach us how to use (I literally learned how to edit videos from your other videos too)

@jeninemaggio7757 Ай бұрын

I paid so much money to a course through a local university to learn Office and I end up on your videos because you explain it so much better than they do. Thank you!

@elenipanayiotou7660 3 жыл бұрын

Brilliant. Clear and straight to the point. Easy to understand. Thank you

@d3w4yn3 Жыл бұрын

Another quite simple and direct and accurate video! My ADHD thanks you, good Sir, for a job well done!!!

@trinabobina7674 3 жыл бұрын

Awesome, thanks for this! 👍🏼 putting together a huge tracking spreadsheet for work and this formula is a life saver

@RickBeall 11 ай бұрын

You could not ask for this to be any clearer. Thanks!

@MartySlice 4 жыл бұрын

Hey man, thanks a million for the help. I'm working on some modules for work and the instructions that we're given are completely vague and lacks proper directions. THIS was insanely helpful. I just hit the subscribe button. Thanks again.

@MohamadShurrab 3 жыл бұрын

Thanks Kevin for your efforts on the countif/s functions... great work and very helpul.

@jj-zm9of Жыл бұрын

thank you so much for your good lesson!!! very straight to the point and easy to comprehend !

@HalpPlsxx01 Ай бұрын

I didn't know that the "=COUNTIFS" function requires 2 sets of condition for it to work. This video helped it break it down for me. Thanks alot!

@mahaboobkhan786 3 жыл бұрын

With the help of this video I solved my headache worksheet. Thanks alot Mr.Kevin Stratvert. God bless you.

@haydenjohnwhite 4 жыл бұрын

I am a brand new accounting student. Literally in my first unit, in my first semester. You sir are a life saver! Thank you so much, you have a new subscriber :-)

@damilolaoluwanisola5580 Жыл бұрын

Thanks so much I can never forget this tutorial. So helpful

@vrisshtisingh8061 3 жыл бұрын

THANKSSSS....after checking so many videos, finally I got here what I was looking for!

@johnfriesen6156 2 жыл бұрын

Great video very informative to understand. You're a good teacher. Thank you.

@lijokurianjacob8879 4 жыл бұрын

Thank you Kevin, it really helped me a lot

@EmekaAmuta 18 күн бұрын

I really learned a lot from this. Rich examples and great delivery. Thanks for all you do

@Kikamalak 6 ай бұрын

I am addicted to your videos because I became very confident that after watching them, I can call myself an expert in what I just learned. Thank you so much, Kevin! 👍👍👍

@KevinStratvert 6 ай бұрын

Great to hear!

@sirlrado 3 жыл бұрын

Kevin! Kevin! Kevin! You are a star. Thanks for this great video

@kuchkaamkibatain 5 ай бұрын

Year 2024 and it is still helping. Thanks Kevin for the good work!

@user-jv3hk3dn5z 8 ай бұрын

I really learn so much with your videos very well explained, THANK YOU!

@notimeforusernames8256 Жыл бұрын

Great and infomative video! Very easy to understand. great Job!!!

@AlbertDiaz-mx6jp Ай бұрын

I really like your explanation. Clear and very easy to follow. You help a lot of people how to use and understand excel, keep it up bro.! You are a blessing to many. God bless you!

@kristinemoralescamilon Жыл бұрын

Perfect! This is exactly what I'm looking for! Thanks a lot. It'll help me creating my tracker 🥰🥰🥰🥰 Awesome

@zaibieditx2061 Жыл бұрын

I AM NEW TO EXCEL, I DID NOT ONLY LEARNT COUNTIF AND COUNTIFS BUT ALSO THREE MORE USEFULL THINGS I DID NOT KNEW AND TEACHING STYLE IS BEST.

@marlinstudio. 10 ай бұрын

Thank you, well explained...Now to put in to practice.

@VAwitch Жыл бұрын

Thank you - I support multiple programs, and have a spreadsheet for the personnel I'm responsible for with their program & location noted. But couldn't figure out how to set up running tallies of different data points for the inevitable "need the info yesterday" data calls without getting a !SPILL error. I'd figured out how to use COUNTIF, but not how to combine multiple programs or locations without having multiple queries then SUM those cells. Using your walkthrough, I just set up 4 different COUNTIFS that have info I am often asked for, so I can now respond to "Need NOW" emails as fast as I can pull up the spreadsheet. You've saved me a lot of time & stress, thank you.

@disconnected7571 3 жыл бұрын

Thanks for helping as revision for my test tomorrow! :)

@naisharlubega9267 Жыл бұрын

Thank you I understood almost everything

@hakunamatata7138 2 жыл бұрын

You just cleared my one month lesson in one video... thank you soooo much.. you saved me😄

@sirbumarianleonard6909 5 ай бұрын

Straight to the point ! Thank you!

@HodjaTheNoob 3 жыл бұрын

Thank you! That document really helped.

@watericeproject695 3 жыл бұрын

wow! very clear explanation! Thanks a lot!

@nadiabee4818 Жыл бұрын

This so helpful, Thank you Kevin.

@nikkierina Жыл бұрын

Tqvm for all the guidance especially for beginner.

@purplesalt152 2 жыл бұрын

You're a real hero dude. Thank you

@martinnhantran 3 жыл бұрын

Thanks Kevin, these are some sick function tips

@crazymelophile9454 2 жыл бұрын

You saved alot of my time thank you so much for sharing this information. 💜

@BrendanKupeThomas-tp1hh 9 ай бұрын

You are brilliant. You,be very helpful to for almost 3 years now. 👍😎

@bryanacobo653 Ай бұрын

Your the answer to my Hows, thanks alot..

@anirbanpaul129 4 жыл бұрын

Very much interesting & useful also. Keep making this type of videos .

@DEARTETE 6 ай бұрын

you know how to teach, you made it easy with ease and patience, thank you. will base my search on your channel then:)

@TeacherZul 2 ай бұрын

This is really helpful. I've been searching how to count how many B if A in two different rows.

@priyadas2406 2 жыл бұрын

Thank you so much for this video Kevin!

@user-gr3ue9nl3v 8 ай бұрын

Thank you for the awesome tutorial!

@user-sn5jk1wo8q 4 ай бұрын

excellent class ,, thank you so much kevin

@martinpoveda1732 3 жыл бұрын

Thank you so much! Such a great video.

@donnahopkins5468 Жыл бұрын

easy to understand and follow Thank you

@smdmr82 Жыл бұрын

So usefull and simple, keep it up man.. greetings from Turkey 😉

@shiou6841 Жыл бұрын

thanks for the info, it's very helpful ! I appreciate it a lot

@carenasemerel1953 2 жыл бұрын

Thanks so much, you save me hours of head aches

@sonjahammes2391 10 ай бұрын

Thank you very much. Very helpful

@user-hf3yz6kq1r Жыл бұрын

Very helpful! Thank you!

@1crazycatmobilegaming 2 жыл бұрын

Tysm these videos have really helped with revision for my upcoming test! Wish me luck it's tomorrow

@imcintyre01 4 жыл бұрын

5:00 first check point 6:52 second check point 8:24 third checkpoint 10:55 final lap FINISHED!

@user-tp6le9qh9k 4 ай бұрын

This made my job easier, thanks!!!

@misaelruiz8023 2 жыл бұрын

Great. Thank you for share your knowledge..👍

@sanfran224 4 жыл бұрын

Thanks Kevin, good job

@friday8118 2 жыл бұрын

I think out of this whole video the fact that you called the '&' by its real name was, most awesome, I had to look it up.

@Nonkululeko_Blessings.1 2 жыл бұрын

+1 Subscriber and gonna ask my hubby,sisters to follow you... I love you ♥️

@nino_blazic_9565 2 жыл бұрын

Great video! Thanks a lot man!

@rohankelkar1995 2 жыл бұрын

it was helpful, Thank you

@martinabuya8982 5 ай бұрын

Thank you Kevin. Liked your countif presentations.Simple and variety of countif , countifs were simple and easy to understand. 🎉 Please feature power query importing and cleaning financial data from SAP, ORACLE; csv, pdf

@user-eq5gu5tm4j 2 жыл бұрын

omg!!! you are amazing, your help is soooo valuable!!!!

@qiqi7861 2 ай бұрын

that's so helpful. thanks a lot

@agatadroanca6534 Жыл бұрын

thank you, very useful! 💛

@nlbsports8137 8 ай бұрын

Wow thanks bro, youve literally saved me hours of work. Its not that I didn't know the formula, but I was underperforming it. I didn't know that the "range" could deal with multiple sets of data at once. I was using this function for each row for thousands of samples instead of using the "range" to combine everything and calculate a full table of data in one cell....not sure if you get me, lol but thanks this helped

@kienfemichaeltemesgen9168 Жыл бұрын

Thank you very much my brother

@modupeomootemi5193 5 ай бұрын

I now understand how to use the countif and countifs function

@revikoreparambil8702 Жыл бұрын

Very good and to the point

@derricksichilima7719 2 жыл бұрын

great work sir nice explanation and easy to get it

@shakawathossain5532 4 жыл бұрын

A well effective session.

@lalitbhatt3640 Жыл бұрын

Awesome bro ! love from India

@denisagesa6499 2 жыл бұрын

greatly tutorial. thank you

@md.jawadjahangiri636 8 ай бұрын

Very helpful video

@binabasia7495 2 жыл бұрын

Great course! thanks

@DoofenschmertzEI Жыл бұрын

Good stuff here. Just used this to fix a major problem with accountability on a spreadsheet used by a group for work reasons.

@sabrysobeih1839 2 жыл бұрын

Thanks a million ❤

@mrx1.088 3 жыл бұрын

Nice and very helpful video.👏 Subscribed😊

@tlterrell 4 жыл бұрын

Thank you!

@prakashbhattarai5550 2 жыл бұрын

Really easy. thanx.

@bububuna1624 Жыл бұрын

YOU ARE AMAZING!!!!!!

@mohammadyousaf3514 3 жыл бұрын

nice way of explanation keep it up

@nbjamspice 3 жыл бұрын

This awesome. I really loved the "wild card" tutorial on how to count "start with" and "end with". I will be using this feature a lot. My biggest issue is how to copy the formula and paste to multiple columns without changing the formula. I always have to do redo the formula for each column. I'm teaching myself how to do metrics and I work with a company that have 32 groups and always have to show results for each month or for multiple criteria.

@davenicholas5637 3 жыл бұрын

After you copy the formula, hit the "ESC" key, then paste the formula in another cell.

@nbjamspice 3 жыл бұрын

Thanks

@trotterbruno6570 11 ай бұрын

nice job. this really helped with my spreadsheet for work. i had 2 sheets that didn't balance...i suspected the 300's were the difference...actual error was 299.20 . used the countif to work out one sheet had 41 on, other had 42. not only was this quicker , it was far more accurate than if i'd done it manually. very useful trick as i often get this type of issue. ( having found the big diff, i then zero'd in on the smaller diff of 0.80 soon anyway ! :) )

@ivonnelopez8203 3 жыл бұрын

For the red and yellow example, instead of adding 2 countif formula's can I just use countifs instead? What is the difference between count multiple items and countifs?

@nurainbintiomarmoe9115 Жыл бұрын

TQ keVIN.. LOVES THIS

@LaChambola 2 жыл бұрын

THANK YOU!!!

@maryadebimpe9424 Жыл бұрын

Thank you so much

@mingmingdynamite3507 3 жыл бұрын

you explain it better than my teacher

@jamesalexander4411 3 жыл бұрын

Great tutorial Kevin, however, I have single cells in my spreadsheet with multiple numbers that I'm trying to summarize. For example cell E:7 contains the numbers 2,3,5,7,9, 12. I want to ask Excel to tell me how many times the number "2" appears in cell E:7. I think this isn't possible no matter where I put the wildcard asterisk as Excel is reading all my number entires as one single number. ANy suggestions would be appreciated. Thank you.