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
10 ай бұрын
Awesome to hear! 😊
@corneliusd3688
2 жыл бұрын
Wow! After so many searches for tutorial on countif, I consider myself very luck to find your video. Thank you!
@MyOnlineTrainingHub
2 жыл бұрын
Glad it was helpful!
@k0kizzle
13 жыл бұрын
Thank you so much ! I have a midterm tomorrow and this helped me out loads
@shaukathussain9360
4 жыл бұрын
Thank you so much, this was so helpful! God Bless 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?
@astghkarakelyan1102
12 жыл бұрын
THIS CLASS WAS THE BEST, I COULD NOT FIND AN EXPLONATION LIKE THIS, THANK YOU
@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!
@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
@marijn1950
8 жыл бұрын
This is the best explanation possible, thanks a lot!
@MyOnlineTrainingHub
8 жыл бұрын
+Marijn Kroes Thank you! Glad I could help.
@jasonhorn901
Жыл бұрын
Very helpful. Thanks for taking the time to put this together. 🙂
@MyOnlineTrainingHub
Жыл бұрын
My pleasure! Glad I could help 😊
@TwinThingCustomMotorcycles
13 жыл бұрын
thanks for taking the time to do this, your a life saver ;)
@NarutoUzumaki306
11 жыл бұрын
Thank you very much!! It helped me for my exam. God Bless you!!
@irfanbokhari5692
4 жыл бұрын
Thanks for such a useful tutorial.
@3nygma
6 жыл бұрын
Love you! you have saved my life!
@MyOnlineTrainingHub
6 жыл бұрын
Glad I could help, Rick :-)
@wahidovich2021
4 жыл бұрын
Very informative, thank you!
@harvest1236
9 жыл бұрын
thanks, your explanation is very good and easy to understand...
@MyOnlineTrainingHub
9 жыл бұрын
Shandy Wijaya, thank you! Glad I could help.
@ArminaMexico
5 жыл бұрын
You save my life, thank you!
@krialva_4780
5 жыл бұрын
You are wonderful! Thank you!
@MyOnlineTrainingHub
5 жыл бұрын
Aw, thanks Kristina!
@richardmkangala2162
2 жыл бұрын
Thank you so so much! This really helped a ton :)
@MyOnlineTrainingHub
2 жыл бұрын
You're very welcome!
@wiserthanatenyearold
4 жыл бұрын
You just saved my life! Thank you.
@jonathanharvey6592
9 жыл бұрын
Really excellent video!
@paradise_corp
13 жыл бұрын
This helped out so much!!! Great explanation :) 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
@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 :)
@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;"
@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
@20taa
12 жыл бұрын
Thank you very much. this helped a lot :)
@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
@gosheneric9901
6 жыл бұрын
nice explanation, thanks a lot
@MyOnlineTrainingHub
6 жыл бұрын
You're welcome, Eric :-)
@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
@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.
@sa159753sa
7 жыл бұрын
Thank you!
@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
@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.
@rph247
2 жыл бұрын
Sweet!
@MyOnlineTrainingHub
2 жыл бұрын
Thanks!
@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
@horebiswajit2010
9 жыл бұрын
THANKS FOR THIS VIDEO
@shadazad4506
4 жыл бұрын
thank you much love ;)
@MyOnlineTrainingHub
4 жыл бұрын
Thanks, Shad :-)
@jamesperry3837
10 жыл бұрын
Great! Blessings4sharing.
@helenakhan3190
11 жыл бұрын
I did drag and drop the formula but it doesn't come. Can anyone help me?
@fahadal-shammari3472
7 жыл бұрын
Excellent
@MyOnlineTrainingHub
7 жыл бұрын
Cheers, Fahad :-)
@mahmouds1515
5 жыл бұрын
thanks a lot
@MyOnlineTrainingHub
5 жыл бұрын
You're welcome :-)
@FeverVFX
8 жыл бұрын
cheers
@TheConorwalsh
13 жыл бұрын
Cheers LINDA
@Ahmedtall11
8 жыл бұрын
Thanks
@MyOnlineTrainingHub
8 жыл бұрын
You're welcome :-)
@ganeshy45
8 жыл бұрын
thanks..
@shaukathussain9360
4 жыл бұрын
i need your online excel class
@shaukathussain9360
4 жыл бұрын
How you will teach me online about MS office
@quatersrb
12 жыл бұрын
tnx
@arturoguzman5230
4 жыл бұрын
Wow is in Excel 2014 nov
@arturoguzman5230
4 жыл бұрын
2007 😅
@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
@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
@sulmage9926
9 жыл бұрын
much appreciated :)
@nanokd
11 жыл бұрын
Thank you so much, this was so helpful! God Bless you !
Пікірлер: 92