81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Returns the numerical average value in a dataset, ignoring text.

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.


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.