https://www.myonlinetraininghub.com/excel-2007-%e2%80%93-countif-and-countifs-formulas-explained Visit for more Free Microsoft Office training. Watch this video to learn how to use COUNTIF and COUNTIFS formulas in Excel.

Amazon Auto Links: No products found.

I did drag and drop the formula but it doesn’t come. Can anyone help me?

if I use countif to total a number of items that meet certain criteria, how do I count the ones that do not meet the criteria

thanks..

cheers

tnx

Excellent

Great! Blessings4sharing.

You are wonderful! Thank you!

This is the best explanation possible, thanks a lot!

THANKS FOR THIS VIDEO

Thank you!

Thank you so much ! I have a midterm tomorrow and this helped me out loads

nice explanation, thanks a lot

Thanks

Thank you very much. this helped a lot 🙂

Thank you very much!! It helped me for my exam. God Bless you!!

Another great video, that unfortunately doesn’t address my situation. Using your example: I would want to know how many times a number appears in the Units column that is greater than 3, but less than 10, which in this example would be 3. For my purpose, cells D2 through D7 are a named range. Thanks.

thank you very much, i have an exam tomorrow and i didn’t know how to do the countif formula and you have helped me a lot

This helped out so much!!! Great explanation 🙂

Thanks!

thanks for taking the time to do this, your a life saver 😉

THIS CLASS WAS THE BEST, I COULD NOT FIND AN EXPLONATION LIKE THIS, THANK YOU

thanks, your explanation is very good and easy to understand…

Cheers LINDA

will like to know how to count cells, but some cells contain numbers and a letter other just numbers and some just lettes. I want to count the numbers only even if it has a letter with it

Thank you so much, i was tearing my hair over a report and you made it look so easy. could you please take the trouble of explaining how did you get – instead of zero when you applied the formula

Thank you so much, this was so helpful! God Bless you !

Thanks for the feedback. I’m glad it was helpful.

much appreciated 🙂

Love you! you have saved my life!

Really excellent video!