Select the cell where you want the average to appear
Type `=AVERAGE(range)`
Replace `range` with the cells you want to average, such as `A1:A10`
Press Enter
To average non-adjacent cells, use `=AVERAGE(A1,A3,A5)`
To average multiple ranges, use `=AVERAGE(A1:A10,C1:C10)`
To ignore blank cells and text, use the AVERAGE function as normal
To average only visible cells in a filtered list, use `=SUBTOTAL(101,range)`
To average a row, use `=AVERAGE(A1:Z1)`
To average a column, use `=AVERAGE(A1:A100)`
To use AutoSum, select the cell and choose Average from the AutoSum drop-down