How to use COUNTIF and COUNTIFS in Microsoft Excel

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:

As full-disclosure, I work at Microsoft as a full-time employee.

[kristineamnahazlewood]

This has been the most easy to understand COUNTIF/S tutorial for BEGINNERS like me.

Very helpful, thanks!

[danieldesio]

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!

[noyondas]

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

[jeninemaggio]

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!

[riotjohnson]

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)

[haydenjohnwhite]

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 :-)

[xxandyxx]

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

[imcintyre]

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

[Kikamalak]

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! 👍👍👍

[HalpPlsxx]

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!

[cynthiawoodall]

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

[dwyn]

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

[zaibieditx]

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.

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

[hakunamatata]

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

[MartySlice]

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.

[AlbertDiaz-mxjp]

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!

[mahaboobkhan]

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

[RickBeall]

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

[sirlrado]

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