COUNTVISIBLE

Returns the number of visible, non blank cells in a range.

text

Remarks

* This function excludes hidden cells.
* This function excludes hidden cells caused by AutoFilter, Grouping or that have been Manually Hidden.
* You can use the COUNT function to include hidden cells.
* The equivalent VBA function is COUNTVISIBLE

 A
1??



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