AVERAGEAVISIBLE

Returns the average value from the visible, non blank cells in a range (including logical values and text).

Remarks

* This function excludes hidden cells.
* You can use the AVERAGEA function to include hidden cells.
* For instructions on how to add a function to a workbook refer to the page under Inserting Functions