Excel COUNTIF | Multiple Criteria | Greater than or Less Than

COUNTIFS in Excel is one of the more powerful tools you can learn to use. It is just another way to work smarter and not harder. In this video, I’ll show you how to use the two most popular versions of the COUNTIF formula in Excel, along with one really cool bonus tip:
• COUNTIF based on one item/criteria
• COUNTIFS based on multiple criteria ranges and Criteria
• BONUS COUNTIFS using the Less than or Greater than feature in Excel
Here are some more videos you might like:
• SUMIFS in Excel Tutorial • SUMIFS in Excel Tutori...
• Excel Budget Template • Excel Budget Template ...
• Excel Date formulas • Date Formulas in Excel...
Thanks again for watching. Don’t forget to hit subscribe and the bell notification so that RUclips notifies you next time I post a new video - which is about once a week. Also, please support my channel’s growth by liking the video and leaving a comment!

[@barthenning8696]

Great work! Very helpful. These videos are the perfect combination of short and straight to the point but with enough detail to understand.

[@whyworksmarternotharder]

Wow! Thanks for the kind words!

[@haho5101]

Thank you a lot! I'm not good at excel but you make it so easy to follow and understand! Highly appreciate!

[@theadventuresofembrunguy2825]

Your videos are great. Very informative and easy to follow along. Thanks very much.

[@pauls7056]

Thank you. I am using Mac Numbers but it worked the same. I was trying to get answers to >X or

[@carlosabacaz7673]

You´ve help me to get some work done that otherwise would have been done at hand, thank you so much for this video

[@hanshausen2676]

The instructor did an excellent job of explaining why he did each step.

[@JJ-vb2ki]

This is just what I needed! Thanks. Learning about these powerful tools really helps, but it would also help to hear the basics, like when entering the criteria 0, the argument needs to be in "", like ">0". Maybe too basic?

[@peggymartes6054]

This was very helpful, exactly what i was looking for. Great Work

[@michellemiranda4052]

This was very very helpful! Thank you so much for the tutorial

[@slcarey17]

Thank you! Your videos are so helpful.

[@davidpomije1419]

Clear and concise, thanks

[@clintonkahler2082]

informative, to the point...great tutorial....earned my thumbs up! Thanks.

[@seatwarmer]

This was amazing! This makes my media database much easier for counting different names and such! Thank You!

[@adnanabdull4h]

Thank you! Clear instruction!

[@lucianj4564]

This helped me get ready for a case study, thanks!

[@tanyawalker1673]

Excellent video, explained simply, thank you!

[@selvanaiyadurai8967]

Excellent work!. Thank you, infinity times.

[@nehalshah1106]

Very helpful, concise, to the point, thank you

[@eylonashkenazi3218]

Great explanation thank you very much

[@chrisfoskinis]

thank you for the video! I'll definitely watch others from you.

[@rdgad]

Thank you so much... This really helped.

[@tylerp3199]

Fantastic. So well explained.

[@ninacarlaalvarez9389]

Sooo helpful! Thank you so much!

[@dmc8996]

Very Concise and Informative Presentation! Great Job!

[@vramarathnam]

excellent teaching. Thank you very much

[@24johnny24]

THANK YOU for this video!

[@gracyellenm]

Thank you!!!! Was going insane with that already!!

[@ezequieldeleon93]

Thanks for the help!

[@areabdulrazakolalekan6473]

Beautiful. The video assisted me to complete my assignment

[@nigelmirama6875]

Useful, straight to the point.

[@leros27]

great work! EASY TO UNDERSTAND

[@jeanettesefers8180]

Awesome video. Very helpful. Thank you.

[@pillo2701]

Great video
thanks!

[@danepalmer6631]

Super helpful. Thank you.

[@joann87]

very helpful. Thank you!!

[@kehaseneway7116]

INTERESTING, THANK YOU!

[@ganz0325]

Very helpful, thanks a lot

[@word_of_christ_ministries7033]

Awesome and well described.

[@Bicycleboy13]

Thanks! good explaining!

[@dinom1353]

This guy is great at explaining this simply

[@aaronlacey1637]

Very clear, thank you

[@irisjackson2191]

Excellent training!!

[@whyworksmarternotharder]

Thank you! Let me know if there is anything else you’d like to see!

[@amandadewart7523]

Awesome Thank you

[@tashreeqasvatasvat6667]

Thank you for your help. Very useful

[@whyworksmarternotharder]

Glad it was helpful!

[@DianeDenneny]

works great thanks

[@JohnGitau-qq9nj]

Thank you very Much Sir this helped me solve a biig Challenging Problem

[@johnnylippert3]

Thank you great video

[@abrahamwipf95]

Love your work

[@urjitbanerjee9810]

FANTASTIC

[@JuiceGuy07]

VERY helpful WSNH! Keep up the good work!

[@whyworksmarternotharder]

Thank you much! Will do!

[@tamunaakhvlediani5400]

Thank you! I needed this video, this was exactly what I needed :)

[@whyworksmarternotharder]

Glad it was helpful!

[@shawn3pesos]

just bumped into your video, i think is very helpful, i appreciate it

[@whyworksmarternotharder]

Glad to hear it!

[@bearerdenis6660]

Thanks this is very helpful

[@gjermundlindstad]

Excellent!

[@jaimelabbe7445]

Clear and Concise.

[@simrangupta7251]

It was extremely helpful..thanks !

[@whyworksmarternotharder]

Awesome. Welcome. And thank you!

[@milcajessie]

Thanks Bro! Helps a lot.

[@keriharrington4913]

Great Tutorial

[@JeromeSimpsonHDHA]

Exactly what I was looking for thanks

[@fmbamel]

Thank you!

[@DhruvRajSharma]

Thank you for this!

[@whyworksmarternotharder]

My pleasure!

[@lieslhutchings8988]

Exactly what I was looking for! Thank u

[@whyworksmarternotharder]

Glad I could help!

[@biodunwilliams8752]

Thank you for your video. I wish there was sample data to practice.

[@shannonvaden9865]

Helpful!

[@arjiecanillo8929]

Thaa k you. Very helpful. More power.

[@mevshah8866]

YESS, THANK YOU!

[@caitlinminney3748]

This was so helpful!

[@nabaasajudithable]

Thank you this helped me

[@daniellamaryammohamedmokht243]

Super helpful!

[@jasongrace2589]

Hello @worksmarternotharder thank you for your excellent video. Maybe you could explain the solution to the following problem. What could I do if I had a cell which has the month number in it for example 2 for February depending what month has been selected at first and now I want to use the countifs to tell me how many contracts are still running after the month 2. I cannot type ">2" because the value keeps changing so it looks more like >$J$1. Do happen do have an idea?

[@kumarinancy8810]

Loved the video

[@johnbryant239]

Thanks for the help. The third one was the money

[@saadmuhammad1744]

Great video!

[@virtualamilia]

Awesome!

[@sulaimanal-busaidi9285]

thanks for the lesson

[@whyworksmarternotharder]

My pleasure!

[@BestLeaderEver]

Great job.

[@MrRezarss]

You saved my day. Thumbs up.

[@danielwambua161]

cool presentation of countif'

[@bentleylewis1990]

Thanks!

[@andrewphillips5559]

Nice, great video!

[@tofaelahmed1559]

Thanks it’s very helpful video love from Bangladesh

[@marioperera4829]

Thanks, super useful

[@whyworksmarternotharder]

Thanks!

[@sarawananboss2459]

Thanks for upload

[@piyushpoddar1737]

Very helpful brother. Well done!!

[@whyworksmarternotharder]

Thanks. I appreciate your comment! Helps out my channel!!

[@robertstevens1537]

The use of logical operators really helped.

[@sadriddinkhonboev9887]

great work

[@wakyayajacobmordecai9045]

Great one

[@gb18f50]

Learned a lot

[@darrielandashton]

thank you

[@whyworksmarternotharder]

Thank you!!

[@ryanthomas1609]

really good to the point videos!!

[@whyworksmarternotharder]

Awesome thank you!

[@OverRauZA]

Thank you

[@fwd105]

Great tutorial

[@whyworksmarternotharder]

Thank you! Cheers!

[@DROIDFARM]

Sweet!

[@MevludinShah]

Great video, thank you! Only one question; How would you set a criteria more than 45min (>45) but less than 50min (

[@chinturaj3919]

Got any video for that task please do reply

[@MevludinShah]

@@chinturaj3919 I had to work my way around this, I counted one and minused it with the other. Like done the count of those equal or more than 65% and minused it with the count of 75% or more. formula I used is here. =COUNTIF($K$5:$K$65,">=60%")-COUNTIF($K$5:$K$65,">=75%") . I'm sure ​ @Work Smarter Not Harder has a better solution :-)

[@fmneruda5129]

@@MevludinShah Friend, thanks for the idea, I was looking for a way to do exactly this and it helped a lot. All the best!

[@pratamasukawijaya9653]

thanks a lot

[@joecarr3539]

thanks for the help!

[@whyworksmarternotharder]

Sorry for the delay in response! I’m glad it worked out for you

[@tebogoikaneng727]

thank You

[@lawrengoudeaulinzy9895]

Amazing ❤

[@abcotraders5482]

Great video

[@Pisulinac13]

Thanks bro