Solving Excel COUNT Problems with COUNTIFS Function (practice file included)

The Excel COUNTIFS function is perfect for counting cells based on multiple criteria.

What You’ll Learn:
- How to use COUNTIFS
- Differences between COUNTIF and COUNTIFS
- Count cells with multiple conditions
- Use COUNTIFS with OR conditions
- Count cells not equal to a value
- Count cells greater than a number
- Handle blank and non-blank cells
- Count cells between dates in Excel
- Count cells with partial text using wildcards

00:00 COUNTIFS Function in Excel
00:46 COUNTIF vs COUNTIFS
01:21 COUNTIFS Function in Excel with Multiple Criteria
03:37 Excel COUNTIFS OR
05:17 Excel COUNTIFS Not Equal To
06:20 Excel COUNTIFS Greater Than
07:29 Excel COUNTIFS Not Blank
08:42 Excel COUNTIFS Date Range
09:59 Excel COUNTIFS Contains Partial Text
11:42 Wrap Up

➡️ Join this channel to get access to perks:

🎬 LINKS to related videos:

🚩Let’s connect on social:

This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel

[exwork]

Beautiful. Short, concise, precise 👏 I'll put this video in my newsletter, let it spread!

[LivingGuy]

I just realized that newer versions of excel don't require you to do anything special for arrays, I'm very happy that I upgraded!

[chh]

It may be dark and raining outside, but it always feels like a bright sunny day when I can start it off with a Prof. Leilia video. Once again, shining a light on a topic I would not have noticed.

A very pleasant surprise ... thank you ... thank you ... thank you ... 😍😍😍

[stevebulls]

As always, a gem of a tutorial! I've played with COUNTIFS but this explains what a couple hours of playing MIGHT have. Thanks, Leila!!

[bigE]

Great video as always! If you want to count cells that contain text you can use "><" in the criteria.

[BillyG]

I love your knowledge ❤You look amazing with your glasses.

[Kenayi]

A very timely tutorial for me. Many thanks

[koborkutya]

love your reading glasses, make a great impact :)

[vrjaiswal]

WOW the notification message ... very creative.

[jimmeade]

Thanks so much for this. I didn't even realize my Excel had a COUNTIFS function. I've always used various combinations of COUNTIF, sometimes having to move data to other cells and/or worksheets to do what I need.

[WiFiJeremy]

You do such a great job explaining and expanding on concepts. Great Stuff.

[davidmunro]

Leila, Please note that the wild card is called an "aster isk" not an "aster ix". Asterix the Gaul was a Frenchman in cartoons. Sorry for the comment but you are not the only one in Excel who says this. I would also like to say that your videos are very helpful and so clearly explained. I watch almost every one of them. Please keep up your good advice. Thank you!

[chrism]

Great video Leila, the wildcard part was very cool

[Tkourtog]

Great and informative video as always Leila. Thanks for sharing.

[newmandoss]

You always good, start from simple and break the complex

[davidunwin]

I can't believe your doing a video on this. I tried using Countifs last week and tried to do the "greater than" example you did but I didn't have quotation marks and I couldn't get it to work! Amazing! Thanks so much! And thanks Google for listening to my conversations and suggesting the video. 😂

[WarrenWilsonChem]

Really liked this as I have used and struggled with this function in the past

[ricardomurillo]

You and your examples are amazing. Nice glasses 😎, gives a beautiful intellectual look.

[vx]

I enjoy countifs, and use it in a biweekly report to management. Thank you for this super tutorial on so many uses, and I can surely add these use cases to my repertoire ❤. Thank you again, and love your very becoming glasses - I'm still on the hunt for good ones!

[pegmolter]

Very timely and helpful! Syntax for this function (and its cousins) is non-intuitive; I would NOT have figured out all these differences on my own. Thanks!!