SUMVISIBLE

SUMVISIBLE(unit)
Returns the sum of values from the visible, non blank cells.

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