Five Ways To Fix Your AVERAGE Function | Google Sheets
Learn how to correctly arrive at the average of a series of values. It is not always a straightforward process depending on how your data is arranged and how you want to treat certain values.
More information on the AVERAGE and AVERAGEA functions:
https://sheetshelp.com/average/
https://sheetshelp.com/averagea/
Timestamps:
0:00 Intro
0:24 AVERAGE Function
1:12 Not all numbers
3:23 Hidden rows
5:09 Error handling
6:58 Boolean values (true/false checkboxes)
7:53 "Subaverages"
8:50 SUM with SUBTOTAL
Learn more from Prolific Oaktree:
🌳 Next Video - Spreadsheets 3.0 - • Video
🌳 Related Playlist - Google Apps | Full Tutorials - https://bit.ly/google-tutorials
#googlesheets #AVERAGE #AVERAGEA