Use `=AVERAGE(range)` to calculate the average of the values in a range
Use `=AVERAGE(range1, range2)` to calculate the average of multiple ranges
Use `=AVERAGE(A1:A10)` for a single set of values
Use `=AVERAGE(B1:B10)` for another set of values
Use `=AVERAGE(AVERAGE(A1:A10),AVERAGE(B1:B10))` to calculate the average of averages
Use `=SUM(A1:A10,B1:B10)/COUNT(A1:A10,B1:B10)` to calculate the true overall average
Use `=AVERAGE(C1:C5)` if the average values are already in cells
Use `=AVERAGE(C1:C5,D1:D5)` to average multiple average results
Use `=SUMPRODUCT(AVERAGEIF(…))` only when averaging grouped averages with different weights
Use `=SUM(all_values)/COUNT(all_values)` when you need the weighted average of all underlying data