Select the cell where you want the average to appear
Type `=AVERAGE(`
Select the range of cells you want to average
Close the formula with `)`
Press `Enter`
Example: `=AVERAGE(A1:A10)`
To average non-adjacent cells, use commas
Example: `=AVERAGE(A1,A3,A5)`
To average multiple ranges, separate them with commas
Example: `=AVERAGE(A1:A5,C1:C5)`
To ignore blank cells, use `AVERAGE`
To average only visible cells, use `SUBTOTAL(101,range)`
To average cells based on a condition, use `AVERAGEIF`
Example: `=AVERAGEIF(A1:A10,”>0″)`
To average cells based on multiple conditions, use `AVERAGEIFS`
Example: `=AVERAGEIFS(C1:C10,A1:A10,”Yes”,B1:B10,”>50″)`