The Excel AVERAGEIFS Function

Подписаться 1,5 млн

Просмотров 136 тыс.

50% 1

Learn how to use the AVERAGEIFS function in Excel. This useful function enables you to average only specific cells based on criteria that you specify. ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... See my entire playlist of Excel videos: bit.ly/tech4excel Here is the practice file that goes with this video: bit.ly/averageifs #excel #exceltutorial #advancedexcel

Хобби

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

22 ноя 2020

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

I just found your channel, looking for editing documents in word videos. Thank you for investing your time in teaching us with such clarity.

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

Thank you So much for this video. It's so informative. The best part is your video is so easily understandable and very informative. Thank you

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

great videos I became very expert in computer on watching ur videos, thanks.

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

Thanks a million! You are the best for excel I found. You are very clear and straight to the point. Can you recommend a channel that is as good as you that does Quickbooks. Thank you!

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

You the Real MVP! This helped me with my excel midterm!

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

I am a total beginner with excel. I am not going for business but I do take care of inventory of products. My job doesn't have anything official way of keeping track of it and it bugs me. Plus, I want to keep track of my own stuff using Excel anyways. Thank you!

@TheYellowshuttle Год назад

Very nice explanation! Easy to understand. 👌❤️

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

This video helped me a lot. Thank you so much

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

amazing. Thank you!

@lynnzhang5015 10 месяцев назад

nice video, thank you

@ashokgurhekar5189 Год назад

Very useful function, Thank you sir 🙏👍

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

Man you're a lifesaver 😍

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

Very good!

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

Good Explanation

@Abduljalil-sb6vd 3 года назад

I am very impressed form your video lacture.and thank u sir.

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

Thanks a million.

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

As usual, another excellent video, thank you! Please accept a small correction: In your video, the Test Score in line 8 is 58 but the practice file in same line has a value 57, thus the Average Score is 77 instead of 77.14285714

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

Another (and quickest) way is a pivot table. Just click on one cell in the data range and Insert/Pivot Table (or key Alt,N,V). Drag Grade level to the Rows Box, and Test Score to Values. Select Average (instead of Sum) of Test Score. Be aware though that if you add or subtract a student record you have to right-click/Refresh to change the Pivot Table (whereas the formula method in the video updates automatically).

@adarsh9436 Год назад

I was searching for this exact tip for my university work, thank you so much you are a lifesaver! :)

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

Pretty cool stuff in this video. Take notes, students 😁👍

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

@Ashton Franco You're right. Nobody gives a damn, trust me.

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

EXCELLENT!

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

Can you help how to compere program language evolution using excel chart please

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

in averageifs, what if the average range has 2 or more columns?

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

This is exactly what I am trying to figure out too!

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

I like the fact that you dont mention hit the like button or subscribe till the end.

@mohammadsyed2135 Год назад

hi really like the video but would be better if it was shorter and to point

@accountingkuniya 2 месяца назад

SUPAR

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

83.84 74.19 55.81 43.97 42.9 27.05 Sir, I have above 6 numbers only in column or row, but I need only those three numbers out of above 6 numbers that give me average of 50 or nearby 50 (+5 or -5) I want those three numbers, highlighted or separated automatically.