Definition. This function calculates the average of the values in an argument list. Not only numbers but also text and logical values (TRUE and FALSE) are included in the calculation.
value1 (required) and value2 (optional). At least one and up to 255 arguments (30 in Excel 2003 and earlier versions) for which you want to calculate the average
The arguments can be numbers, names, arrays, or references.
Remember that empty cells are treated differently from cells with the value 0. Empty cells are not counted, but 0 values are. If you activate the zero values option for cells with the value 0, you can see which cells are really empty and which contains ...