
Excel AVERAGE Function
Use:
- Computes unweighted arithmetic mean of a set of data
Syntax:
- AVERAGE( range )
Examples:
- Cell D12 formula: AVERAGE( C4:G4 )
Cell D13 formula: AVERAGE( D3:D9 )
Cell D14 formula: AVERAGE( C3:G9 )
Cell D15 formula: AVERAGE( D3:D9,G3:G9 )
Note:
- AVERAGE( range ) is equivalent to SUM( range ) / COUNT( range )
Related Functions:
- MEDIAN, MODE, SUM,
COUNT, COUNTA