How to use the COUNTIFS function in Excel

Learn how to use the COUNTIF function in Microsoft Excel. This tutorial demonstrates how to use Excel COUNTIF to count cells based on one or more criteria. We provide 3 easy to follow examples and take you step-by-step through the different options when entering your formula.

COUNTIFS Function (and sample data):

COUNTIF Function:

Excel Functions/Formulas:

Excel Tutorials:

Don't forget to subscribe to our channel for more great Excel tutorials!

or follow us on:

[DiwakarKankipati]

After referring to multiple sources, this video helped on COUNTIFS with date range

[somadinasmbg]

Thank you so much for sharing this ❤. I watched from Nigeria ❤

[sinayaya]

I learned a lot from this channel.
Thank you very much!

[PFG]

Thank you for the video!
I like how your video are short and simple while providing all the required information! Way better than those other talking head videos!!!
Liked and subscribed! Keep up the good work!

[diamondjustinegeronimo]

This is what I'm looking for. Thank you !

[kikaroohajibung]

Thank you much, this video help me a lotttt !! Wish you and your team have a great journey!! 😘

[jossymundo]

Thank you guys, I gave you a like and subscribed. This content is easy to understand and straight to the point, I love it.

[Empyreanis]

Thanks for the help! I hope we pass our thesis this time.

[yaritzamartinez]

Yesss! This was sooo helpful and needed! I have data where it repeats criteria names for different months and you helped me crack the code to group them soo easy!

[kollingtonugbegan]

Awesome. Just the function I needed. Thanks, Guys.

[ovyeyit]

Thanks A lot .. this video makes me better in excel and saves a lot of time of working .. appreciated ❤️

[Pankaj-Verma-]

The video was really helpful.
Great trick.

[jobharath]

Thank you for your very succinct ct examples…

[wildwestgunslinger]

Thanks for the video, pretty easy to understand

[capdocean]

im most defiantly gonna use this in my future i bet

[yunogasai]

Saved my assignment in statistics. Thank you so much.

[derricksichilima]

very helpful madam and goood explanation