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 TH-cam 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!

[@haho5101]

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

[@hanshausen2676]

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

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

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

[@theadventuresofembrunguy2825]

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

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

[@seatwarmer]

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

[@peggymartes6054]

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

[@clintonkahler2082]

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

[@dmc8996]

Very Concise and Informative Presentation! Great Job!

[@michellemiranda4052]

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

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

[@slcarey17]

Thank you! Your videos are so helpful.

[@davidpomije1419]

Clear and concise, thanks

[@nehalshah1106]

Very helpful, concise, to the point, thank you

[@dinom1353]

This guy is great at explaining this simply

[@gracyellenm]

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

[@areabdulrazakolalekan6473]

Beautiful. The video assisted me to complete my assignment

[@chrisfoskinis]

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

[@leros27]

great work! EASY TO UNDERSTAND

[@jeanettesefers8180]

Awesome video. Very helpful. Thank you.

[@nigelmirama6875]

Useful, straight to the point.

[@tylerp3199]

Fantastic. So well explained.

[@adnanabdull4h]

Thank you! Clear instruction!

[@rdgad]

Thank you so much... This really helped.

[@24johnny24]

THANK YOU for this video!

[@ninacarlaalvarez9389]

Sooo helpful! Thank you so much!

[@eylonashkenazi3218]

Great explanation thank you very much

[@vramarathnam]

excellent teaching. Thank you very much

[@word_of_christ_ministries7033]

Awesome and well described.

[@pillo2701]

Great video
thanks!

[@ezequieldeleon93]

Thanks for the help!

[@danepalmer6631]

Super helpful. Thank you.

[@keriharrington4913]

Great Tutorial

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

[@joann87]

very helpful. Thank you!!

[@saadmuhammad1744]

Great video!

[@tamunaakhvlediani5400]

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

[@whyworksmarternotharder]

Glad it was helpful!

[@Bicycleboy13]

Thanks! good explaining!

[@JohnGitau-qq9nj]

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

[@ganz0325]

Very helpful, thanks a lot

[@andrewphillips5559]

Nice, great video!

[@johnbryant239]

Thanks for the help. The third one was the money

[@gjermundlindstad]

Excellent!

[@danielwambua161]

cool presentation of countif'

[@robertstevens1537]

The use of logical operators really helped.

[@shawn3pesos]

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

[@whyworksmarternotharder]

Glad to hear it!

[@tofaelahmed1559]

Thanks it’s very helpful video love from Bangladesh

[@kehaseneway7116]

INTERESTING, THANK YOU!

[@MrRezarss]

You saved my day. Thumbs up.

[@JeromeSimpsonHDHA]

Exactly what I was looking for thanks

[@arjiecanillo8929]

Thaa k you. Very helpful. More power.

[@mpendulombatha3704]

Great work sir. I have a question when you hit F4 to make the values absolute his you did that? I have been trying n trying but I'm failing

[@caitlinminney3748]

This was so helpful!

[@abrahamwipf95]

Love your work

[@urjitbanerjee9810]

FANTASTIC

[@JuiceGuy07]

VERY helpful WSNH! Keep up the good work!

[@whyworksmarternotharder]

Thank you much! Will do!

[@amandadewart7523]

Awesome Thank you

[@jaimelabbe7445]

Clear and Concise.

[@chelseawilliams393]

Is there a way to make the count if formula for values greater than zero but less than the value in a different cell? like for scoring. Who got over a zero but under how many points were complete.

[@johnnylippert3]

Thank you great video

[@biodunwilliams8752]

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

[@aaronlacey1637]

Very clear, thank you

[@BestLeaderEver]

Great job.

[@EthosLegos]

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

[@whyworksmarternotharder]

Glad it helped!

[@daniellamaryammohamedmokht243]

Super helpful!

[@milcajessie]

Thanks Bro! Helps a lot.

[@ShaneSaltzman]

Is it possible to use the greater than sign to on a cell reference. Meaning in the last part of video (5:50) minutes greater than cell J1 or 45 mins?

[@SiriusPunk]

Is there a way to do this using the TODAY function for the dates?

[@bearerdenis6660]

Thanks this is very helpful

[@DianeDenneny]

works great thanks

[@LyricalOnYt]

a question please, I am working on a sheet for electric bill, so there is rate difference by units consumed, if units consumed are less than 100 the rate is different, is its less then 200 its different and so on so forth for the each 100 units window. how can I set it up so that it automatically knows the value is less then 100 or 200 and with which number it has to multiply the value, please help.
(English is not my first language so I hope you got what I meant)
Thanks in advance

[@wakyayajacobmordecai9045]

Great one

[@shannonvaden9865]

Helpful!

[@sadriddinkhonboev9887]

great work

[@abcotraders5482]

Great video

[@tashreeqasvatasvat6667]

Thank you for your help. Very useful

[@whyworksmarternotharder]

Glad it was helpful!

[@tongvang724]

How do you use this to import data from an external workshert? I'm having trouble and cant seem to import dates range from external worksheet.

[@lieslhutchings8988]

Exactly what I was looking for! Thank u

[@whyworksmarternotharder]

Glad I could help!

[@virtualamilia]

Awesome!

[@JohnDouglas-rs1ge]

Answered most of my question. Using your example need to determine minutes to complete BETWEEN 45 and 60. I've tried a number of combination's but not getting correct results.

[@irisjackson2191]

Excellent training!!

[@whyworksmarternotharder]

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

[@lenzildsouza8874]

Hi...sir could you please explain the sumifs with 2 or more criteria using same example of this video...as it fits perfectly with the work role of mine..thank you sir..
Looking forward to hear from you..

[@nabaasajudithable]

Thank you this helped me

[@DhruvRajSharma]

Thank you for this!

[@whyworksmarternotharder]

My pleasure!

[@mevshah8866]

YESS, THANK YOU!

[@dimpleadalja2198]

Hi I need to look at 2 criteria within one range and I need to look at the other column which will give me the exact time for that range. How do i do that? Sorry if i confused you.

[@sarawananboss2459]

Thanks for upload

[@fmbamel]

Thank you!

[@simrangupta7251]

It was extremely helpful..thanks !

[@whyworksmarternotharder]

Awesome. Welcome. And thank you!

[@gb18f50]

Learned a lot

[@tmaheshganapathy]

HI., Is it possible to compare a single cell to multiple cell using Countif function., In that case is it possible to return a logical value

[@lawrengoudeaulinzy9895]

Amazing ❤

[@ardianaz5599]

How to input a double criteria, like for example if i wanted to take A B from A1:A50 with A B C D, and i want the criteria to have double input for what the total of A-B in the A1:A50. What are the formula??

[@travisanderson893]

Helpful 😊

[@piyushpoddar1737]

Very helpful brother. Well done!!

[@whyworksmarternotharder]

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