How to use the COUNTIF function in Excel

Learn how to use the COUNTIF function in Microsoft Excel. This tutorial demonstrates how to use Excel COUNTIF with an easy to follow example and takes you step-by-step through the different options when entering your formula.
COUNTIF Function (and sample data):
www.techonthen...
Excel Functions/Formulas:
www.techonthen...
Excel Tutorials:
www.techonthen...
Don't forget to subscribe to our channel for more great Excel tutorials!
Visit us at: www.techonthen...
or follow us on:
Facebook: / techonthenetcom
Twitter: / tech_on_the_net
Pinterest: / techonthenetcom

[@hotmilo]

I'm in college and have been busy with excel for more than a month. I'm preparing for a test based on excel and after watching your videos I fully understand all the functions I've been struggling to learn.

[@hotmilo]

I forgot to give an update. I got the highest grade out of 80, 90% ☺️

[@goodlife6145]

And here I've been for so many years believing Excel was difficult. You teach this information very well. Cheers.

[@evanreagan]

Thank you, this was my first time trying this without the workbook. I subscribed!

[@heeeydevon8262]

This makes so much sense! You need an indicator cell to tell the COUNTIF formula what it's looking for

[@captainx9565]

Thank you, I was going mad as I know the formula works and is so useful, but I had missed the comma between the range and "*"

[@clevelandtyler2]

This just saved me a lot of time and eye strain. Thank you so much

[@ruruthewitch]

IKR

[@gdmrhotshot3731]

im taking a data science class and im using this for help so thank you

[@olgafilipchuk7763]

YOUR TUTORIALS ARE VERY GOOD! THANK YOU! THOSE COMMENTS ASIDE ARE VERY HELPFUL!

[@Techonthenetcom]

Glad you like them!

[@onionmonster8795]

Thank you so much! Great video

[@irtmm9370]

Thank you for being so straightforward

[@SanjayKapoorDelhi]

Thanks a ton!! This solved a problem I was facing in a worksheet

[@Techonthenetcom]

Great!

[@Disable-f1w]

am your first subscriber that why

[@ananou712]

Thank you for being so clear

[@MariaCrafts7]

Thanks for the helpful information

[@RR0000]

really well explained indeed :-) thank you very much and people like yourself make a real difference thank you for this

[@joshichirag351]

Thank you, i was using , after the range so i couldn't able to do it. After your video i got the real formula so thank you so much.

[@voiceofshinkairadio3651]

This is too good thanks TechOnTheNet team.

[@owenptv3460]

thank u for this informative tutorial..

[@Bharath.Silambaveeran]

Thanks Awesome video. This is useful who attend practical exam.

[@Techonthenetcom]

Glad it was helpful!

[@LynBuhalog]

thank you for sharing! it is very helpful :)

[@robertodhiambo6148]

Very helpful

[@TutanComputerGuide]

Nice video 👍

[@Techonthenetcom]

Thanks!

[@gcnewd]

Thank you

[@ZlatkaGocheva]

Thank you!

[@pbyt3869]

Thank you so much

[@BrunoSilvino]

can I use a formula to define the range for the function? ie. =COUNTIF( FORMULA, CRITERIA)

[@auberlinkeyanpi9377]

Thanks a million

[@russellcruz2260]

can you also discuss the formula on "product" sheet?

[@Anush_Sivakumar]

THANKS A LOT !!! AWESOME VDO!!

[@mobilierclasic2707]

I love you so much

[@salnaud8898]

short and useful

[@iwkpsaccount]

thank u bro

[@erikhakim6092]

thanks

[@leonchirinda5338]

Yes ma'am

[@shah00le]

i love u

[@Abdulrafaywn9rz]

Hi

[@orometsetswai7586]

Your sumif and countif are the same

[@michaelparker1299]

hiya

[@terrencestamps5125]

Thank you