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.
Nesta página do site você pode assistir ao vídeo on-line AVERAGEIF - Practical Example| Google Sheets Formulas 44 duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Google Workspace Tutorial 16 Outubro 2021, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 254 vezes e gostou 13 espectadores. Boa visualização!
