Formula Engine Reference Guide
 

 

Back to Class Index

 

AVG(argumentlist)

Description
Returns the average (arithmetic mean) of its arguments. Blank cells and strings are ignored.
 
Parameters
argumentlist
Any combination of numbers, cells, or ranges
 
Examples
AVG(A1, B9, J32, F16) = 21.125
where A1 = 12, B9 = 34.5, J32 = 22, F16 = 16
 
AVG(A1, A12..H13, 111+32) = 135.67
where we don't really care what is at those variables, but which shows that you can use numbers, ranges, and expressions all together as arguments for AVG.