Excel COUNTIF | Multiple Criteria | Greater than or Less Than

Подписаться 80 тыс.

Просмотров 226 тыс.

50% 1

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 RU-vid 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!

Опубликовано:

27 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 241

@UserEHag 19 дней назад

THIS MAN JUST HELPED ME GREATLY ON EXCEL ASSIGNMENTS IN MY BUSINESS STATISTICS CLASS.

@hanshausen2676 2 года назад

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

@seatwarmer 3 месяца назад

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

@caitlinnealey3390 16 дней назад

I have been looking for this video for a very long time. Thank you!

@pauls7056 2 года назад

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

@dinom1353 2 года назад

This guy is great at explaining this simply

@kendimuchungi3749 2 месяца назад

This was very helpful. I have subscribed and look forward to learning more.

@gracyellenm 2 года назад

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

@lucianj4564 Год назад

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

@EthosLegos Год назад

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

@whyworksmarternotharder Год назад

Glad it helped!

@Lucero.Katherine Год назад

YES THIS WORKS, The error was because I was using a comma, but using a semicolon fixed it.

@feridrehimli5191 Год назад

Thank youuuuuuuu. It was hours that I couldn't find. Your comment survived me. You're the best!!!!!!!!! 👍

@michellemiranda4052 Год назад

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

@selvanaiyadurai8967 Год назад

Excellent work!. Thank you, infinity times.

@chrisfoskinis Год назад

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

@shawn3pesos Год назад

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

@whyworksmarternotharder Год назад

Glad to hear it!

@johnbryant239 2 года назад

Thanks for the help. The third one was the money

@ezequieldeleon93 2 года назад

Thanks for the help!

@ganz0325 9 месяцев назад

Very helpful, thanks a lot

@slcarey17 2 года назад

Thank you! Your videos are so helpful.

@jaimelabbe7445 Год назад

Clear and Concise.

@pillo2701 2 года назад

Great video thanks!

@andrewphillips5559 3 месяца назад

Nice, great video!

@jeanettesefers8180 Год назад

Awesome video. Very helpful. Thank you.

@theadventuresofembrunguy2825 3 года назад

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

@tashreeqasvatasvat6667 Год назад

Thank you for your help. Very useful

@whyworksmarternotharder Год назад

Glad it was helpful!

@lieslhutchings8988 Год назад

Exactly what I was looking for! Thank u

@whyworksmarternotharder Год назад

Glad I could help!

@clintonkahler2082 2 года назад

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

@leros27 Год назад

great work! EASY TO UNDERSTAND

@JeromeSimpsonHDHA 2 года назад

Exactly what I was looking for thanks

@irisjackson2191 4 года назад

Excellent training!!

@whyworksmarternotharder 4 года назад

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

@bearerdenis6660 2 года назад

Thanks this is very helpful

@rdgad 4 месяца назад

Thank you so much... This really helped.

@DhruvRajSharma Год назад

Thank you for this!

@whyworksmarternotharder Год назад

My pleasure!

@ardianaz5599 3 месяца назад

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

@UceFootball 25 дней назад

Thank you 🙌🏾

@gb18f50 Год назад

Learned a lot

@nabaasajudithable 7 месяцев назад

Thank you this helped me

@eylonashkenazi3218 7 месяцев назад

Great explanation thank you very much

@JohnDouglas-rs1ge 4 месяца назад

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.

@BestLeaderEver Год назад

Great job.

@urjitbanerjee9810 Год назад

FANTASTIC

@simrangupta7251 4 года назад

It was extremely helpful..thanks !

@whyworksmarternotharder 4 года назад

Awesome. Welcome. And thank you!

@arjiecanillo8929 11 месяцев назад

Thaa k you. Very helpful. More power.

@lenzildsouza8874 7 месяцев назад

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

@ninacarlaalvarez9389 2 года назад

Sooo helpful! Thank you so much!

@Williams76 2 месяца назад

So wonderful ❤

@johnnylippert3 Год назад

Thank you great video

@danepalmer6631 Год назад

Super helpful. Thank you.

@soulfulblack 18 дней назад

Great assistance

@mustaphaazeez8092 2 месяца назад

Learnt something new

@Bicycleboy13 11 месяцев назад

Thanks! good explaining!

@biodunwilliams8752 Год назад

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

@fwd105 Год назад

Great tutorial

@whyworksmarternotharder Год назад

Thank you! Cheers!

@tylerp3199 3 года назад

Fantastic. So well explained.

@fmbamel 3 месяца назад

Thank you!

@sulaimanal-busaidi9285 Год назад

thanks for the lesson

@whyworksmarternotharder Год назад

My pleasure!

@dimpleadalja2198 4 месяца назад

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.

@danielwambua161 Год назад

cool presentation of countif'

@kehaseneway7116 2 года назад

INTERESTING, THANK YOU!

@JLIdam Год назад

Thank you for the video...the only thing I am trying to figure out is the sum of total minutes....any help would be appreciated...

@abcotraders5482 11 месяцев назад

Great video

@shannonvadenconst Год назад

Helpful!

@word_of_christ_ministries7033 2 года назад

Awesome and well described.

@aaronlacey1637 Год назад

Very clear, thank you

@sarawananboss2459 2 года назад

Thanks for upload

@sadriddinkhonboev9887 Год назад

great work

@user-iq9ye6vf6z Год назад

Hi Thanks a lot for countif's

@milcajessie 3 года назад

Thanks Bro! Helps a lot.

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

@virtualamilia 7 месяцев назад

Awesome!

@chelseawilliams393 6 месяцев назад

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.

@brijeshshah574 Год назад

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

@DNAReactions 2 года назад

thank you

@whyworksmarternotharder 2 года назад

Thank you!!

@daniellamaryammohamedmokht243 Год назад

Super helpful!

@lawrengoudeaulinzy9895 9 месяцев назад

Amazing ❤

@mevshah8866 2 года назад

YESS, THANK YOU!

@abrahamwipf95 3 года назад

Love your work

@synthiamehezabin5889 3 месяца назад

Can I get the excel data to practice myself?

@oONeMesiS0o Год назад

How do you do countifs with 3 criterias but no duplicates on the 3rd criteria?

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

@galvezfelipearellano 4 года назад

Thanks!

@whyworksmarternotharder 4 года назад

Thank you for the comment! It helps my channel!

@sivasubramanian1533 Год назад

Will it work across the sheets?

@travisanderson893 Год назад

Helpful 😊

@6uardian4ngel65 3 месяца назад

Helpful :)

@ryanthomas1609 3 года назад

really good to the point videos!!

@whyworksmarternotharder 3 года назад

Awesome thank you!

@mpendulombatha3704 2 года назад

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

@ricardoshillyshally4593 2 месяца назад

Can I use countifs with multiple ranges?

@jasongrace2589 2 года назад

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?

@bnhammond26 3 года назад

Very helpful. Thank you

@whyworksmarternotharder 3 года назад

Awesome! Thanks for the kind words!

@SiriusPunk 3 года назад

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

@victoriahowson6280 2 года назад

Great video but every time I use countif it returns 0 even though I use "" around the text I'm looking for. It's really frustrating! Why is that happening?

@redrose1441 Год назад

While mentioning greater than criteria , can we refer to a cell to change the criteria like “>B2” instead of “>45” . It’s not working . Can anyone guide ?

@pratamasukawijaya9653 Год назад

thanks a lot

@DROIDFARM 2 года назад

Sweet!

@blainebaker8919 4 года назад

THANKS!

@whyworksmarternotharder 4 года назад

Thank you for the comment! Much appreciated! It helps with the YT algorithm

@khalidsalih9787 Год назад

CHEERS, THANK YOU

@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

@jordanhudson883 7 месяцев назад

Thanks

@debonairLADY 2 года назад

You are great explaining, thank you. I wonder if you can help me to figure out how to use this to get percentage of completion of a questionnaire with Yes, No and open answers; this questionnaire has different stages, ex. week 1, week 2, 30 days, 60 days and 90 days to see if training is appropriate to new hires. We want to be able to track if it is being completed on time.

@whyworksmarternotharder 2 года назад

I’d check this video out ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Jl964i0UuCY.html