How to use the COUNTIFS function in Excel

Learn how to use the COUNTIF function in Microsoft Excel. This tutorial demonstrates how to use Excel COUNTIF to count cells based on one or more criteria. We provide 3 easy to follow examples and take you step-by-step through the different options when entering your formula.
COUNTIFS Function (and sample data):
www.techonthenet.com/excel/fo...
COUNTIF Function:
www.techonthenet.com/excel/fo...
Excel Functions/Formulas:
www.techonthenet.com/excel/fo...
Excel Tutorials:
www.techonthenet.com/excel/in...
Don't forget to subscribe to our channel for more great Excel tutorials!
Visit us at: www.techonthenet.com
or follow us on:
Facebook: / techonthenetcom
Twitter: / tech_on_the_net
Pinterest: / techonthenetcom

Пікірлер: 69

  • @avaruth7651
    @avaruth76514 ай бұрын

    Made it so easy! Thank you!

  • @elar6383
    @elar63834 жыл бұрын

    Awesome, just what I needed Thanks!

  • @DiwakarKankipati
    @DiwakarKankipati3 жыл бұрын

    After referring to multiple sources, this video helped on COUNTIFS with date range

  • @sinayaya8662
    @sinayaya86624 жыл бұрын

    I learned a lot from this channel. Thank you very much!

  • @somadinasmbg
    @somadinasmbg6 ай бұрын

    Thank you so much for sharing this ❤. I watched from Nigeria ❤

  • @diamondjustinegeronimo298
    @diamondjustinegeronimo298 Жыл бұрын

    This is what I'm looking for. Thank you !

  • @yaritzamartinez1111
    @yaritzamartinez1111Ай бұрын

    Yesss! This was sooo helpful and needed! I have data where it repeats criteria names for different months and you helped me crack the code to group them soo easy!

  • @kikaroohajibung9088
    @kikaroohajibung90884 ай бұрын

    Thank you SOOOOO much, this video help me a lotttt !! Wish you and your team have a great journey!! 😘

  • @samanmaeruf
    @samanmaeruf4 жыл бұрын

    Thank you you are the best 👍

  • @jossymundo9287
    @jossymundo92874 ай бұрын

    Thank you guys, I gave you a like and subscribed. This content is easy to understand and straight to the point, I love it.

  • @kollingtonugbegan9714
    @kollingtonugbegan97143 жыл бұрын

    Awesome. Just the function I needed. Thanks, Guys.

  • @user-ov8ye3yi6t
    @user-ov8ye3yi6t3 жыл бұрын

    Thanks A lot .. this video makes me better in excel and saves a lot of time of working .. appreciated ❤️

  • @Empyreanis
    @Empyreanis2 жыл бұрын

    Thanks for the help! I hope we pass our thesis this time.

  • @princessepanda6886
    @princessepanda6886 Жыл бұрын

    the way you explain is amazing

  • @PFG888
    @PFG888 Жыл бұрын

    Thank you for the video! I like how your video are short and simple while providing all the required information! Way better than those other talking head videos!!! Liked and subscribed! Keep up the good work!

  • @paullarkin9177

    @paullarkin9177

    9 ай бұрын

    This video is the benchmark for online learning, in my humble but educated experience. For example, there is no talking head that serves only to distract from the learning process. A minimalist approach that is focused on learning without a "real" teacher.

  • @nmestre2
    @nmestre24 жыл бұрын

    Thank you so much! ♥

  • @swapnilmishra9111
    @swapnilmishra91113 жыл бұрын

    Thank you! 😊

  • @Pankaj-Verma-
    @Pankaj-Verma-2 жыл бұрын

    The video was really helpful. Great trick.

  • @particleonazock2246
    @particleonazock22463 жыл бұрын

    The only video that actually helped.

  • @ra_wolf560
    @ra_wolf560 Жыл бұрын

    So useful! thanks a lot

  • @ajanthanjeyarajan5747
    @ajanthanjeyarajan57473 жыл бұрын

    Thank you!

  • @wildwestgunslinger6995
    @wildwestgunslinger69953 жыл бұрын

    Thanks for the video , pretty easy to understand

  • @Techonthenetcom

    @Techonthenetcom

    3 жыл бұрын

    Glad to hear that!

  • @jobharath2812
    @jobharath28128 ай бұрын

    Thank you for your very succinct ct examples…

  • @shabbarmostafa
    @shabbarmostafa21 күн бұрын

    Thank you

  • @capdocean7822
    @capdocean78224 жыл бұрын

    im most defiantly gonna use this in my future i bet

  • @jenniferngpeiwen9427
    @jenniferngpeiwen94273 жыл бұрын

    Thank you very much. You saved my friendssssssss

  • @Techonthenetcom

    @Techonthenetcom

    3 жыл бұрын

    Glad to hear that

  • @balajis27
    @balajis2710 ай бұрын

    Great explanation

  • @Uma7473
    @Uma74734 жыл бұрын

    Thank u so much

  • @stitch-fitfashionlifestyle8148
    @stitch-fitfashionlifestyle81483 жыл бұрын

    Thank you 💕

  • @drnanditachaturvedi6011
    @drnanditachaturvedi6011 Жыл бұрын

    Super helpful. Thanks

  • @petrescumarinela
    @petrescumarinela3 жыл бұрын

    Clear and simple! Thanks a lot.

  • @emk6360
    @emk63603 жыл бұрын

    Thank you very much.

  • @yunogasai4183
    @yunogasai41833 жыл бұрын

    Saved my assignment in statistics. Thank you so much.

  • @Ok-vm7lg
    @Ok-vm7lg5 ай бұрын

    really useful thank you

  • @BilalAkram-qm4cc
    @BilalAkram-qm4cc4 ай бұрын

    This is what I'm looking for.

  • @maxmillman9477
    @maxmillman94773 жыл бұрын

    Good tutorial, cheers.

  • @vasiuddinkhan5505
    @vasiuddinkhan5505 Жыл бұрын

    Nice ❤️❤️❤️

  • @rohanpatil550
    @rohanpatil5502 жыл бұрын

    Thank you for all i am understand it's easily

  • @sangamgrouppune
    @sangamgrouppune3 жыл бұрын

    Thanks a lot.

  • @alysiapwilson
    @alysiapwilson3 жыл бұрын

    Clearly explained, thank you

  • @itsmenm8399
    @itsmenm83992 жыл бұрын

    Awesome 👍

  • @SBAK4444
    @SBAK44442 жыл бұрын

    Thank you -

  • @dominicinthecity6267
    @dominicinthecity62672 жыл бұрын

    Thanks love ❤️

  • @derricksichilima7719
    @derricksichilima77192 жыл бұрын

    very helpful madam and goood explanation

  • @rosandoval711
    @rosandoval7114 жыл бұрын

    Question: How would you count the total cost for 2013, Oranges, using the countifs formula? I'm unclear what will come after the C2:C9,"=?") to give the total cost.

  • @stefanoc974
    @stefanoc9743 жыл бұрын

    thank you

  • @ankitasrivastav6367
    @ankitasrivastav6367 Жыл бұрын

    Very good

  • @Bleu-en2bf
    @Bleu-en2bf3 жыл бұрын

    Excellent🌟

  • @Techonthenetcom

    @Techonthenetcom

    3 жыл бұрын

    Thanks a lot

  • @JosephBenedictMaguddayaoTe
    @JosephBenedictMaguddayaoTe4 жыл бұрын

    How about if it’ll only count how many is in the selected range?

  • @JordansMom769
    @JordansMom7692 жыл бұрын

    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.

  • @pinkybhardwaj9154
    @pinkybhardwaj91542 жыл бұрын

    Thank u

  • @LearnBulk
    @LearnBulk3 жыл бұрын

    Nice

  • @saburjonsaidov2904
    @saburjonsaidov29043 жыл бұрын

    NIce video

  • @thehealingvibration
    @thehealingvibration4 жыл бұрын

    this is SO AWESOME. I just need to know one more thing: I want to add two COUNTIFS, and one of the values is multiplied by two. In other words, COUNTIFS the value is "s" as 1 and COUNTIFS the value (in the same column) is "d", multiply x 2 and add to the count of "s". I am so close!!

  • @andydidyouhear
    @andydidyouhear3 жыл бұрын

    Is the order in which we input the criteria important?

  • @cocenthusiast0109

    @cocenthusiast0109

    7 ай бұрын

    No

  • @vivekshah518
    @vivekshah5182 жыл бұрын

    What if I want the cost for oranges bought in 2013

  • @kiromaged4167
    @kiromaged41674 ай бұрын

    Ict exam tdy : 🤡

  • @norma-jeabarsh5266
    @norma-jeabarsh526610 ай бұрын

    What if you want to use countif(positive numbers)-countif(negaive numbers)

  • @norma-jeabarsh5266

    @norma-jeabarsh5266

    10 ай бұрын

    Looked like it worked!

  • @afolabirahman612
    @afolabirahman612 Жыл бұрын

    Thank you

  • @senthilp7238
    @senthilp72382 жыл бұрын

    thank you

  • @gamemonster7
    @gamemonster73 жыл бұрын

    Thank you