AVERAGEA Function – Google Sheets

The AVERAGEA calculated the mean of a set of values similar to AVERAGE, but offers additional functionality. When all inputs to the function are numbers, it produces the same result as the AVERAGE function. However, when the inputs are text or boolean values, the AVERAGEA function acts differently than AVERAGE. Get your copy of the template used in … Read more

AVERAGE Function – Google Sheets

The AVERAGE function calculates the mean of a set of values in your spreadsheet while ignoring any non-number values. See AVERAGEA if you want to average boolean values or count text as zero instead of ignoring it. Make a copy of this spreadsheet template to follow along with the examples. Purpose The AVERAGE function returns … Read more