AVERAGEIF - Practical Example| Google Sheets Formulas 44
In this lesson, We are going to explore:
0:00 Getting started.
0:28 AVERAGEIF - practical example.
All explanations are simple and to the point.
Feel free to make your copy of this spreadsheet:
https://docs.google.com/spreadsheets/...
#GoogleForEducation #GoogleWorkspace #GoogleSheets
If you found this video helpful, give us an old like and share it with some people you think this could be helpful for. And if you're not already a subscriber, make sure to hit the subscribe button and also the notification bell to be notified every time a video is uploaded
Useful Link:
Ben Collins (Google Developer Expert & Data Analytics Instructor)
https://www.benlcollins.com/
Google Sheets training:
https://support.google.com/a/users/an...
The whole playlist link:
• The most useful formulas - Google Sheets |...
Follow us on Pinterest:
https://www.pinterest.it/GoogleWorksp...
Sound from Zapsplat.com
Apple logo
https://iconscout.com/contributors/pi...
Windows logo
https://pixabay.com/it/users/
Welcome back, Educators.
Our mission is to calculate the average scores of the students who passed the exam.
And also, for the students who failed the exam.
To achieve that, we use the AVERAGEIF function.
To facilitate typing the formula, we’ve named the range.
Type = AVERAGEIF(
The criteria range is the scores.
The criterion is greater than 49.
The average range is the Scores range also.
Press Enter.
Copy the formula to the right.
Replace the greater than with less then.
Press Enter.
We’ve done the mission.
That’s it, have fun. Thanks for watching.
If you like the video, please give us a thumbs up.
And subscribe to our channel.
On this page of the site you can watch the video online AVERAGEIF - Practical Example| Google Sheets Formulas 44 with a duration of hours minute second in good quality, which was uploaded by the user Google Workspace Tutorial 16 October 2021, share the link with friends and acquaintances, this video has already been watched 254 times on youtube and it was liked by 13 viewers. Enjoy your viewing!
