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.
На этой странице сайта вы можете посмотреть видео онлайн AVERAGEIF - Practical Example| Google Sheets Formulas 44 длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Google Workspace Tutorial 16 Октябрь 2021, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 254 раз и оно понравилось 13 зрителям. Приятного просмотра!
