Excel COUNTIF & COUNTIFS Video Tutorial

Рет қаралды 396,931

Күн бұрын

Learn how to use COUNTIF and COUNTIFS formulas in Excel. Go here for step by step written instructions: www.myonlinetraininghub.com/e...
View my comprehensive courses: www.myonlinetraininghub.com/
Connect with me on LinkedIn: / myndatreacy

Пікірлер: 92

@astghkarakelyan1102 11 жыл бұрын

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

@k0kizzle 12 жыл бұрын

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

@Silverblue121 8 ай бұрын

Thank you for making this video. I couldn't get my head around how I could show the status for each of the IT tickets for various team members, your video was very clear and I followed your step by steps guidance and now I can show how each team member is progressing - it has saved me hours!

@MyOnlineTrainingHub 8 ай бұрын

Awesome to hear! 😊

@shaukathussain9360 4 жыл бұрын

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

@ArminaMexico 5 жыл бұрын

You save my life, thank you!

@corneliusd3688 Жыл бұрын

Wow! After so many searches for tutorial on countif, I consider myself very luck to find your video. Thank you!

@MyOnlineTrainingHub Жыл бұрын

Glad it was helpful!

@NarutoUzumaki306 10 жыл бұрын

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

@TwinThingCustomMotorcycles 12 жыл бұрын

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

@ammar3776 9 жыл бұрын

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

@paradise_corp 12 жыл бұрын

This helped out so much!!! Great explanation :) Thanks!

@wahidovich2021 4 жыл бұрын

Very informative, thank you!

@MyOnlineTrainingHub 13 жыл бұрын

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

@oliviadargan5056 4 жыл бұрын

Hi There, this is helpful but, if I have a variety of different products and a cycle times that I have captured over a year, how would I lookup a Product ID and find the most occurring cycle time for that product?

@marijn1950 8 жыл бұрын

This is the best explanation possible, thanks a lot!

@MyOnlineTrainingHub 8 жыл бұрын

+Marijn Kroes Thank you! Glad I could help.

@irfanbokhari5692 4 жыл бұрын

Thanks for such a useful tutorial.

@jonathanharvey6592 9 жыл бұрын

Really excellent video!

@20taa 11 жыл бұрын

Thank you very much. this helped a lot :)

@sa159753sa 7 жыл бұрын

Thank you!

@3nygma 5 жыл бұрын

Love you! you have saved my life!

@MyOnlineTrainingHub 5 жыл бұрын

Glad I could help, Rick :-)

@horebiswajit2010 9 жыл бұрын

THANKS FOR THIS VIDEO

@shellyp.7068 4 жыл бұрын

9 years later and you have helped me! Thanks!

@MyOnlineTrainingHub 4 жыл бұрын

Wow! That was a long time ago :-) Glad it's still helpful.

@shellyp.7068 4 жыл бұрын

@@MyOnlineTrainingHub yes it is. I have struggled with many excel assignments trying to figure out why the formula kept copying the same text. Then I came across this video and realized I didn't have the formula correct, so yeah thanks!

@DericHood-zi5cq 8 жыл бұрын

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

@krialva_4780 5 жыл бұрын

You are wonderful! Thank you!

@MyOnlineTrainingHub 5 жыл бұрын

Aw, thanks Kristina!

@jamesperry3837 10 жыл бұрын

Great! Blessings4sharing.

@wiserthanatenyearold 4 жыл бұрын

You just saved my life! Thank you.

@jasonhorn901 10 ай бұрын

Very helpful. Thanks for taking the time to put this together. 🙂

@MyOnlineTrainingHub 10 ай бұрын

My pleasure! Glad I could help 😊

@harvest1236 9 жыл бұрын

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

@MyOnlineTrainingHub 9 жыл бұрын

Shandy Wijaya, thank you! Glad I could help.

@richardmkangala2162 2 жыл бұрын

Thank you so so much! This really helped a ton :)

@MyOnlineTrainingHub 2 жыл бұрын

You're very welcome!

@gosheneric9901 6 жыл бұрын

nice explanation, thanks a lot

@MyOnlineTrainingHub 6 жыл бұрын

You're welcome, Eric :-)

@shadazad4506 4 жыл бұрын

thank you much love ;)

@MyOnlineTrainingHub 4 жыл бұрын

Thanks, Shad :-)

@fahadal-shammari3472 6 жыл бұрын

Excellent

@MyOnlineTrainingHub 6 жыл бұрын

Cheers, Fahad :-)

@TheConorwalsh 12 жыл бұрын

Cheers LINDA

@ganeshy45 8 жыл бұрын

thanks..

@mahmouds1515 5 жыл бұрын

thanks a lot

@MyOnlineTrainingHub 5 жыл бұрын

You're welcome :-)

@dominickcarides5805 10 жыл бұрын

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

@rph247 Жыл бұрын

Sweet!

@MyOnlineTrainingHub Жыл бұрын

Thanks!

@helenakhan3190 10 жыл бұрын

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

@quatersrb 11 жыл бұрын

tnx

@FeverVFX 8 жыл бұрын

cheers

@Ahmedtall11 8 жыл бұрын

Thanks

@MyOnlineTrainingHub 8 жыл бұрын

You're welcome :-)

@JordansMom769 2 жыл бұрын

I know this video is older, but: I'm trying to create a calendar for an online class. I want each month to show out to the side how many weekdays in the month. I've highlighted the squares that are weekdays, and those that do not fall within that month have a light gray fill. The squares that do fall within the month have no fill. So, I've tried: =COUNTIFS(C4:G14,"cells with no fill"), and 1 or 2 others (can't remember exactly because I already undid them) and I've tried COUNTIF also. The result keeps coming up 0. I can't figure out what I'm doing wrong.

@MyOnlineTrainingHub 2 жыл бұрын

You can't count fill colour or lack of it. You can use this formula where the first day of the month is in cell A1: =NETWORKDAYS.INTL(A1,EOMONTH(A1,0)) If you have further questions, please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

@hamzaotm 5 жыл бұрын

How can I do this to workout how many staff I have working at certain time. E.g. 1pm-2pm 4 staff

@MyOnlineTrainingHub 5 жыл бұрын

I would use a PivotTable to group the time field: www.myonlinetraininghub.com/excel-pivottable-group-data-video

@teostoichev6691 4 жыл бұрын

Hi. That was really useful video but please tell me how can I count cells containing different figures but at same range? For example the range A6:A135 is in the same column, the cells I need to count (the criteria) are containing the figures 41, 42, 43 and 44. Is COUNTIF a variant?

@MyOnlineTrainingHub 4 жыл бұрын

You need COUNTIFS e.g.: =COUNTIFS(A6:A135,">"&40,A6:A135,"

@teostoichev6691 4 жыл бұрын

@@MyOnlineTrainingHub Thank you very much! Actually it worked with the following syntaxis: =COUNTIFS(A6:A135;">40";A6:A135;"

@SusieQ-gw8to Жыл бұрын

How can I count a specific word like "doug" in another sheet?

@MyOnlineTrainingHub Жыл бұрын

=COUNTIF(click on range in other sheet, "Doug") Hope that helps. If you're still stuck, post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

@welcometorazdom6065 9 жыл бұрын

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

@MyOnlineTrainingHub 9 жыл бұрын

Welcome to Razdom I'm glad I could help you understand COUNTIF and COUNTIFS. The - displays instead of zero with a custom number format that instructs Excel to display a - instead of zero. You can read more about Custom Number Formats here: www.myonlinetraininghub.com/excel-custom-cell-formats

@welcometorazdom6065 9 жыл бұрын

Thanks for the assistance, God bless you :)

@federicoconiglio 5 жыл бұрын

Hi, how are you? Can I have mulltiple criterias listed? Or just 1

@MyOnlineTrainingHub 5 жыл бұрын

The COUNTIFS function allows you to specify multiple criteria, but only one criteria per column.

@allanmurillo9452 4 жыл бұрын

Hello, can you show us on how to use the countif or count if you are looking for a number of male ages 1, 2, 3 and so fort and number of male and female who are in-school and out of school. thanks

@MyOnlineTrainingHub 4 жыл бұрын

Hi Allan, I'd be glad to help. Please post your question and sample Excel file on our forum where I can see what you're trying to do: www.myonlinetraininghub.com/excel-forum

@fred0447 5 жыл бұрын

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.

@MyOnlineTrainingHub 5 жыл бұрын

Hi Fred, this should work: =COUNTIFS(named_range, ">"&3, named_range, "

@fred0447 5 жыл бұрын

Thank you for your reply. My experience found that COUNTIFS is limited to interrogating multiple ranges, and multiple criteria only, not the same range twice. Since I sent this question to several areas, for clarity, in my particular situation, I have a named range and want to know how many cells within the range contain a number between 500, and 599, or, more than 499 but less than 600. Using COUNTIF, I found this to be the solution: =COUNTIF(namedRange;"499")-COUNT(namedRange) This approach counts each cell in the range, while counting the ones within the criteria twice, then subtracts the range leaving only the criteria. I liked it, but further research found a much more direct, and streamlined solution using SUMPRODUCT instead: =SUMPRODUCT(namedRange>=500;namedRange

@MyOnlineTrainingHub 5 жыл бұрын

Hi Fred, COUNTIFS is not restricted to interrogating multiple ranges. The criteria in a COUNTIFS is considered AND, so this formula: =COUNTIFS(namedRange,">="&500,namedRange,"

@fred0447 5 жыл бұрын

OK. Seems there is always more than one way to skin a cat. But my SUMPRODUCT example does work, exactly as I have described it. I agree SUMPRODUCT could be much more confusing to a novice user than COUNTIF(S), but so are a great many of other functions as well. LOL

@MyOnlineTrainingHub 5 жыл бұрын

Hmm, I'd like to see your file with your SUMPRODUCT formula working as you entered it above, it returns zero for me. Maybe your European (?) settings allow it to work differently, but didn't think that was the case.

@shaukathussain9360 4 жыл бұрын

i need your online excel class

@shaukathussain9360 4 жыл бұрын

How you will teach me online about MS office

@sulmage9926 9 жыл бұрын

much appreciated :)

@arturoguzman5230 3 жыл бұрын

Wow is in Excel 2014 nov

@arturoguzman5230 3 жыл бұрын

2007 😅

@catudiotricia3893 5 жыл бұрын

other part is blurd ! hehe just saying im not understand

@MyOnlineTrainingHub 5 жыл бұрын

:-) please post your question in our Excel forum and we'll guide you through it: www.myonlinetraininghub.com/excel-forum

@amolarunparihar9846 2 жыл бұрын

How to find out in first column Cell A1 - R100 ,B1- Match, Cell A2 - R100 , B2 - Not Match Cell A3- R200, B3 - Not Match Cell A4 R300, B4 - Not match Cell A5 R300,B5 - Not match How to find out only Not match result by formula when there all results are not match then result should be verify

@MyOnlineTrainingHub 2 жыл бұрын

Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum