The Excel AVERAGEIFS Function
Вставка
- Опубліковано 16 вер 2024
- 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
I'm an experienced Excel user. When I search for help I'm always pleased when your channel comes up. I've noticed over the years you do very good videos. You communicate your help very clearly and patiently. Thanks for your channel, I use it a lot. Keep up the great work! I am a subscriber to your channel.
great videos I became very expert in computer on watching ur videos, thanks.
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!
I just found your channel, looking for editing documents in word videos. Thank you for investing your time in teaching us with such clarity.
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
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!
You the Real MVP! This helped me with my excel midterm!
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).
I was searching for this exact tip for my university work, thank you so much you are a lifesaver! :)
Pretty cool stuff in this video. Take notes, students 😁👍
@Ashton Franco You're right. Nobody gives a damn, trust me.
Very nice explanation! Easy to understand. 👌❤️
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
This video helped me a lot. Thank you so much
nice video, thank you
Very useful function, Thank you sir 🙏👍
I am very impressed form your video lacture.and thank u sir.
Very good!
Good Explanation
Thanks a million.
Man you're a lifesaver 😍
amazing. Thank you!
Can you help how to compere program language evolution using excel chart please
EXCELLENT!
I like the fact that you dont mention hit the like button or subscribe till the end.
hi really like the video but would be better if it was shorter and to point
in averageifs, what if the average range has 2 or more columns?
This is exactly what I am trying to figure out too!
SUPAR
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.
first
How can i use a vlookup or index match function to replace criteria. Im trying so hard to find the answer to this.