AVERAGEVISIBLE

AVERAGEVISIBLE(unit)
Returns the

REMARKS
* This function excludes hidden cells caused by AutoFilter, Grouping or that have been Manually Hidden.
* You can use the built-in AVERAGE function to include hidden cells.
* This is similar to the COUNTVISIBLE, MAXVISIBLE, MINVISIBLE and SUMVISIBLE functions.
* This page has the equivalent VBA function.