How to use the COUNTIFS function in Excel

Подписаться 47 тыс.

Просмотров 1 млн

50% 1

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

Опубликовано:

11 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 68

@DiwakarKankipati 3 года назад

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

@elar6383 4 года назад

Awesome, just what I needed Thanks!

@avaruth7651 4 месяца назад

Made it so easy! Thank you!

@diamondjustinegeronimo298 Год назад

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

@somadinasmbg 5 месяцев назад

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

@jossymundo9287 4 месяца назад

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

@sinayaya8662 4 года назад

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

@yaritzamartinez1111 21 день назад

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!

@Empyreanis 2 года назад

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

@kikaroohajibung9088 4 месяца назад

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

@Pankaj-Verma- 2 года назад

The video was really helpful. Great trick.

@drnanditachaturvedi6011 Год назад

Super helpful. Thanks

@nmestre2 4 года назад

Thank you so much! ♥

@samanmaeruf 4 года назад

Thank you you are the best 👍

@princessepanda6886 Год назад

the way you explain is amazing

@jobharath2812 8 месяцев назад

Thank you for your very succinct ct examples…

@swapnilmishra9111 3 года назад

Thank you! 😊

@ra_wolf560 Год назад

So useful! thanks a lot

@ajanthanjeyarajan5747 3 года назад

Thank you!

@kollingtonugbegan9714 3 года назад

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

@particleonazock2246 3 года назад

The only video that actually helped.

@Ok-vm7lg 4 месяца назад

really useful thank you

@emk6360 3 года назад

Thank you very much.

@balajis27 9 месяцев назад

Great explanation

@stitch-fitfashionlifestyle8148 3 года назад

Thank you 💕

@Uma7473 4 года назад

Thank u so much

@sangamgrouppune 3 года назад

Thanks a lot.

@capdocean7822 4 года назад

im most defiantly gonna use this in my future i bet

@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 8 месяцев назад

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.

@itsmenm8399 2 года назад

Awesome 👍

@wildwestgunslinger6995 2 года назад

Thanks for the video , pretty easy to understand

@Techonthenetcom 2 года назад

Glad to hear that!

@rohanpatil550 2 года назад

Thank you for all i am understand it's easily

@SBAK4444 2 года назад

Thank you -

@user-ov8ye3yi6t 3 года назад

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

@petrescumarinela 3 года назад

Clear and simple! Thanks a lot.

@gamemonster7 3 года назад

Thank you

@BilalAkram-qm4cc 3 месяца назад

This is what I'm looking for.

@dominicinthecity6267 2 года назад

Thanks love ❤️

@stefanoc974 3 года назад

thank you

@yunogasai4183 3 года назад

Saved my assignment in statistics. Thank you so much.

@jenniferngpeiwen9427 2 года назад

Thank you very much. You saved my friendssssssss

@Techonthenetcom 2 года назад

Glad to hear that

@ankitasrivastav6367 Год назад

Very good

@alysiapwilson 3 года назад

Clearly explained, thank you

@maxmillman9477 3 года назад

Good tutorial, cheers.

@pinkybhardwaj9154 2 года назад

Thank u

@vasiuddinkhan5505 Год назад

Nice ❤️❤️❤️

@Bleu-en2bf 3 года назад

Excellent🌟

@Techonthenetcom 3 года назад

Thanks a lot

@derricksichilima7719 2 года назад

very helpful madam and goood explanation

@LearnBulk 3 года назад

Nice

@saburjonsaidov2904 3 года назад

NIce video

@JosephBenedictMaguddayaoTe 4 года назад

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

@rosandoval711 4 года назад

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.

@JordansMom769 2 года назад

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.

@kiromaged4167 3 месяца назад

Ict exam tdy : 🤡

@vivekshah518 2 года назад

What if I want the cost for oranges bought in 2013

@thehealingvibration 4 года назад

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