Excel COUNTIF & COUNTIFS Video Tutorial 

Awesome to hear! 😊

Glad it was helpful!

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?

+Marijn Kroes Thank you! Glad I could help.

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

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

My pleasure! Glad I could help 😊

Glad I could help, Rick :-)

Aw, thanks Kristina!

You're very welcome!

Shandy Wijaya, thank you! Glad I could help.

Thanks!

Thanks, Shad :-)

You're welcome, Eric :-)

Cheers, Fahad :-)

You're welcome :-)

You're welcome :-)

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

Thanks for the assistance, God bless you :)

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

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

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

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

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

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

=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

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

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

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,"

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

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.

How you will teach me online about MS office

2007 😅

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

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