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 KZbin 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.

[@selvanaiyadurai8967]

Excellent work!. Thank you, infinity times.

[@clintonkahler2082]

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

[@tanyawalker1673]

Excellent video, explained simply, thank you!

[@peggymartes6054]

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

[@hanshausen2676]

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

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

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

[@chrisfoskinis]

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

[@nehalshah1106]

Very helpful, concise, to the point, thank you

[@dmc8996]

Very Concise and Informative Presentation! Great Job!

[@adnanabdull4h]

Thank you! Clear instruction!

[@jeanettesefers8180]

Awesome video. Very helpful. Thank you.

[@leros27]

great work! EASY TO UNDERSTAND

[@nigelmirama6875]

Useful, straight to the point.

[@seatwarmer]

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

[@24johnny24]

THANK YOU for this video!

[@ninacarlaalvarez9389]

Sooo helpful! Thank you so much!

[@lucianj4564]

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

[@gracyellenm]

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

[@tylerp3199]

Fantastic. So well explained.

[@tamunaakhvlediani5400]

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

[@whyworksmarternotharder]

Glad it was helpful!

[@rdgad]

Thank you so much... This really helped.

[@dinom1353]

This guy is great at explaining this simply

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

[@ezequieldeleon93]

Thanks for the help!

[@vramarathnam]

excellent teaching. Thank you very much

[@pillo2701]

Great video thanks!

[@JuiceGuy07]

VERY helpful WSNH! Keep up the good work!

[@whyworksmarternotharder]

Thank you much! Will do!

[@joann87]

very helpful. Thank you!!

[@danepalmer6631]

Super helpful. Thank you.

[@Bicycleboy13]

Thanks! good explaining!

[@areabdulrazakolalekan6473]

Beautiful. The video assisted me to complete my assignment

[@jaimelabbe7445]

Clear and Concise.

[@kehaseneway7116]

INTERESTING, THANK YOU!

[@word_of_christ_ministries7033]

Awesome and well described.

[@JeromeSimpsonHDHA]

Exactly what I was looking for thanks

[@eylonashkenazi3218]

Great explanation thank you very much

[@caitlinminney3748]

This was so helpful!

[@ganz0325]

Very helpful, thanks a lot

[@arjiecanillo8929]

Thaa k you. Very helpful. More power.

[@aaronlacey1637]

Very clear, thank you

[@andrewphillips5559]

Nice, great video!

[@saadmuhammad1744]

Great video!

[@pauls7056]

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

[@lieslhutchings8988]

Exactly what I was looking for! Thank u

[@whyworksmarternotharder]

Glad I could help!

[@daniellamaryammohamedmokht243]

Super helpful!

[@MrRezarss]

You saved my day. Thumbs up.

[@abrahamwipf95]

Love your work

[@milcajessie]

Thanks Bro! Helps a lot.

[@mevshah8866]

YESS, THANK YOU!

[@gjermundlindstad]

Excellent!

[@urjitbanerjee9810]

FANTASTIC

[@user-hr7sg9db4z]

this video helped me understand thank you

[@tashreeqasvatasvat6667]

Thank you for your help. Very useful

[@whyworksmarternotharder]

Glad it was helpful!

[@keriharrington4913]

Great Tutorial

[@johnnylippert3]

Thank you great video

[@kumarinancy8810]

Loved the video

[@simrangupta7251]

It was extremely helpful..thanks !

[@whyworksmarternotharder]

Awesome. Welcome. And thank you!

[@amandadewart7523]

Awesome Thank you

[@bearerdenis6660]

Thanks this is very helpful

[@irisjackson2191]

Excellent training!!

[@whyworksmarternotharder]

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

[@DianeDenneny]

works great thanks

[@DhruvRajSharma]

Thank you for this!

[@whyworksmarternotharder]

My pleasure!

[@shannonvaden9865]

Helpful!

[@shawn3pesos]

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

[@whyworksmarternotharder]

Glad to hear it!

[@johnbryant239]

Thanks for the help. The third one was the money

[@BestLeaderEver]

Great job.

[@tofaelahmed1559]

Thanks it’s very helpful video love from Bangladesh

[@virtualamilia]

Awesome!

[@danielwambua161]

cool presentation of countif'

[@ryanthomas1609]

really good to the point videos!!

[@whyworksmarternotharder]

Awesome thank you!

[@fmbamel]

Thank you!

[@nabaasajudithable]

Thank you this helped me

[@piyushpoddar1737]

Very helpful brother. Well done!!

[@whyworksmarternotharder]

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

[@biodunwilliams8752]

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

[@JohnGitau-qq9nj]

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

[@robertstevens1537]

The use of logical operators really helped.

[@sarawananboss2459]

Thanks for upload

[@gb18f50]

Learned a lot

[@bentleylewis1990]

Thanks!

[@abcotraders5482]

Great video

[@marioperera4829]

Thanks, super useful

[@whyworksmarternotharder]

Thanks!

[@sadriddinkhonboev9887]

great work

[@sulaimanal-busaidi9285]

thanks for the lesson

[@whyworksmarternotharder]

My pleasure!

[@fwd105]

Great tutorial

[@whyworksmarternotharder]

Thank you! Cheers!

[@lawrengoudeaulinzy9895]

Amazing ❤

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

[@DROIDFARM]

Sweet!

[@joecarr3539]

thanks for the help!

[@whyworksmarternotharder]

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

[@EthosLegos]

Best explanation on excel countif(s), better than my professor.

[@whyworksmarternotharder]

Glad it helped!

[@6uardian4ngel65]

Helpful :)

[@wakyayajacobmordecai9045]

Great one

[@damuscledaddy]

COOL!!!!!

[@darrielandashton]

thank you

[@whyworksmarternotharder]

Thank you!!

[@brijeshshah574]

5:16 Found here what I exactly looking for ✌️👌