Use `=AVERAGE(range)` to calculate the mean
Example: `=AVERAGE(A1:A10)`
Select the cells you want to include
Type `=AVERAGE(` in a blank cell
Highlight the range of cells
Close the formula with `)`
Press `Enter`
Use `=AVERAGEIF(range, criteria)` for a conditional mean
Use `=AVERAGEIFS(average_range, criteria_range1, criteria1, …)` for multiple conditions
Ignore blank cells and text values automatically with `AVERAGE`
Include zeros in the calculation if they are in the selected range