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




© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext