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.
En esta página del sitio puede ver el video en línea AVERAGEIF - Practical Example| Google Sheets Formulas 44 de Duración hora minuto segunda en buena calidad , que subió el usuario Google Workspace Tutorial 16 octubre 2021, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 254 veces y le gustó 13 a los espectadores. Disfruta viendo!
