How to Calculate the Average
in Google Sheets

Open your Google Sheets document and select the cell where you want the average result to appear.

Type the formula =AVERAGE(range), replacing range with the cell range you want to average (e.g., =AVERAGE(A2:A10)).

Press Enter, and the average of the selected range will appear in the selected cell.

Ensure that the range contains numeric values for accurate calculations.

If you need to calculate the average of non-adjacent cells, use =AVERAGE(A2, A5, A8) instead.

For a weighted average, use the =SUMPRODUCT(range1, range2)/SUM(range2) formula.