VehiclesFashionRecipesBlogsHuntTravelsSportFunHandmadeITEducation
Mini-Games
x

x
zakruti.com » Knowledge, science, education » Technology for Teachers and Students
The Excel AVERAGEIFS Function

The Excel AVERAGEIFS Function

FBTwitterReddit

video description

Rating: 4.0; Vote: 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 FromGambit: 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).
Date: 2022-04-08

Comments and reviews: 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!

reply

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
reply

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

reply
Add a review, comment






Other channel videos