COUNTVISIBLEA

COUNTVISIBLEA(rgeValues)
Returns the number of visible, non blank cells in a range (including logical values and text).

REMARKS
* This function excludes hidden cells caused by AutoFilter, Grouping or that have been Manually Hidden.
* You can use the built-in COUNTA function to include hidden cells.
* You can use the add-in COUNTVISIBLE function to
* You can use the add-in COUNTVISIBLEIFS function to
* You can use the user defined AVERAGEVISIBLEA function to
* You can use the user defined MAXVISIBLEA function to
* You can use the user defined MINVISIBLEA function to

For instructions on how to add this function to a workbook refer to the page under Inserting Functions