The Excel COUNTIF and COUNTIFS Functions

Learn to use the powerful COUNTIF and COUNTIFS functions. You can use these functions to tell Excel under what circumstances to count a range of data. Join this channel to get access to perks:
/ @techteachersandstudents
***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: bit.ly/excelcountifs #excel #exceltutorials #microsoft365 #microsoftexcel
Join this channel to get access to perks:
/ @techteachersandstudents

[@cubehire3653]

Excellent lesson thank you. One of the things you did right was not to pipe in distracting music. Your instruction's worked even for me an Excel formula challenged individual.

[@RichieRichIIII]

This channel has provided me so much alpha in excel which has helped me very much @ the work office. ✅

[@rowenaroche2850]

thanks....very easy to understand

[@charliesexton2412]

mine keeps coming back as zero or just shows the function in the cell

[@linbromfield9373]

Thank you, your channel is teaching me so much! Is there any way you can highlight the ones that meet the criteria? I would still have to go through the table looking for the 11 people that weigh over 330

[@karenalcantara316]

Thank you! Very helpful!

[@Miriam-jy7tgz]

Very well explained! thank you!!!

[@milycruz125]

That was extremely helpful. Thank you!

[@markstout8050]

I have a list of 1300 home floor plans of varying square footage but only 103 floor plans. I need to identify which floor plans are +/- 10% of each other as they count as one. For example, a 1300 sf plan and a 1400 sf plan would count as one unique floor plan.

[@michykoh7166]

Do we have a text format that can be 4 option. As of now, it only two option. Sample 1,900 to 1.9 but the hundreds should be the 0.1 the format should be 109. Thank you in advance

[@sherylpilcher7420]

Thank you

[@sunkumar4311]

Please tell me how can I use countifs function link with other excel because counting error found

[@tanjinachowdhury2861]

Thanks boss!

[@talala3600]

Muchas Gracias 😊

[@techteachersandstudents]

De nada amigo.

[@zareh805]

Can't I do that using the filter function by right clicking the top of the column?

[@techteachersandstudents]

Absolutely. Good point. But sometimes it's better to use a formula to generate a number that you can then use in other formulas.

[@martever2012]

How can I use Countif or CountIfs in a dynamic array?

[@ushabhaskar9196]

Can we count and get the sum of those ?

[@StephanieLoeb]

What if you wanted to know whose weight is "between 300-329"?

[@hedayatullaali8701]

Well Arizona with over 329 is only 1 count. Formula is not showing the correct answer.