AVERAGE() – Calculates the average of numbers in a range

AVERAGE(range)

• range: A continuous range of cells whose numeric values you want to average (e.g., T1A1:T1A10).

AVERAGE(T1A1:T1A10)

This formula calculates the average of all numbers in cells T1A1 through T1A10.

Example outputs:

• If cells T1A1:T1A10 contain the numbers [1, 2, 3, 4, 5, 6, 7, 8, 9, 10], the formula returns 5.5 (sum is 55, count is 10, average is 55/10).
• If cells T1A1:T1A4 contain [10, "text", 20, empty_cell], the formula returns 15 (sum is 30 from 10+20, count of numbers is 2, average is 30/2).
• If cells T1A1:T1A3 contain [10, 20, 30], the formula returns 20.

• Arithmetic mean: Calculates the sum of the numbers and then divides by the count of those numbers.
• Ignores text: Text values within the range are ignored and do not affect the sum or the count used in the average calculation.
• Ignores empty cells: Blank cells within the range are ignored and do not affect the sum or the count.

• Calculating the average score of tests, average sales figures, or average temperatures.
• Determining the mean value in a dataset for statistical analysis.
• Finding a typical or central value in a series of numbers.

• Incorrect range specification: Ensure the range is correctly defined.
• Including zero values: Cells containing the number 0 are included in the average calculation (both in the sum and the count). If zeros should be excluded, a different approach would be needed.
• Numbers formatted as text: If numbers are stored as text and not automatically converted by MathGrid for averaging, they will be ignored, potentially leading to an incorrect average.
• Empty or all-text range: If the range contains no numeric values (or all cells are empty or contain text), AVERAGE() will result in an error because the count of numbers would be zero. The IFERROR() function can be used to handle such cases.