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.

[@goodlife6145]

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

[@heeeydevon8262]

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

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

[@evanreagan]

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

[@olgafilipchuk7763]

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

[@Techonthenetcom]

Glad you like them!

[@SanjayKapoorDelhi]

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

[@Techonthenetcom]

Great!

[@irtmm9370]

Thank you for being so straightforward

[@RR0000]

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

[@ananou712]

Thank you for being so clear

[@robertodhiambo6148]

Very helpful

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

[@gcnewd]

Thank you

[@MariaCrafts7]

Thanks for the helpful information

[@owenptv3460]

thank u for this informative tutorial..

[@pbyt3869]

Thank you so much

[@salnaud8898]

short and useful

[@Bharath.Silambaveeran]

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

[@Techonthenetcom]

Glad it was helpful!

[@voiceofshinkairadio3651]

This is too good thanks TechOnTheNet team.

[@mobilierclasic2707]

I love you so much

[@LynBuhalog]

thank you for sharing! it is very helpful :)

[@BrunoSilvino]

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

[@auberlinkeyanpi9377]

Thanks a million

[@iwkpsaccount]

thank u bro

[@ZlatkaGocheva]

Thank you!

[@TutanComputerGuide]

Nice video 👍

[@Techonthenetcom]

Thanks!

[@erikhakim6092]

thanks

[@Anush_Sivakumar]

THANKS A LOT !!! AWESOME VDO!!

[@russellcruz2260]

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

[@leonchirinda5338]

Yes ma'am

[@shah00le]

i love u

[@Abdulrafaywn9rz]

Hi

[@michaelparker1299]

hiya

[@terrencestamps5125]

Thank you