Returns the numerical average value in a dataset, ignoring text.
81% OFF online library of tutorials for mastering Google Sheets
AVERAGE()
Description
How To Use in Sheets
AVERAGE(value1, [value2, ...])
External Links
Google Sheets - Average, Weighted Average, Average Ifs & Conditional Weighted Average
Learn how to calculate averages in Google Sheets. We'll cover AVERAGE, AVERAGEIFS, Weighted Average & Conditional Weighted Average.
2Better Sheets Tutorials
One common feature that users often request is the ability to add star ratings to their spreadsheets. While this feature is not built into Google Sheets, it is possible to create a star rating system using emojis and data validation.
1
What happens very often is we want to figure out an average averages, help us tell the story of a large set of data, but averages also can lie.
2