The Excel COUNTIF and COUNTIFS Functions

74,362

769 0

Published 2024-02-05

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:
youtube.com/channel/UCYUPLUCkMiUgiyVuluCc7tQ/join
***Consider supporting Technology for Teachers and Students on Patreon***: www.patreon.com/technologyforteachersandstudents 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:
youtube.com/channel/UCYUPLUCkMiUgiyVuluCc7tQ/join

All Comments (17)

@rowenaroche2850 4 months ago

thanks....very easy to understand
@RichieRichIIII 3 months ago

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

That was extremely helpful. Thank you!
@cubehire3653 1 month ago

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.
@talala3600 2 days ago

Muchas Gracias 😊
@karenalcantara316 1 month ago

Thank you! Very helpful!
@linbromfield9373 4 months ago

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
@sherylpilcher7420 1 month ago

Thank you
@charliesexton2412 2 months ago

mine keeps coming back as zero or just shows the function in the cell
@zareh805 4 months ago

Can't I do that using the filter function by right clicking the top of the column?
@michykoh7166 3 months ago

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
@markstout8050 2 months ago

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.
@sunkumar4311 2 months ago

Please tell me how can I use countifs function link with other excel because counting error found
@ushabhaskar9196 1 month ago

Can we count and get the sum of those ?
@martever2012 1 month ago

How can I use Countif or CountIfs in a dynamic array?
@hedayatullaali8701 10 days ago

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