SUMVISIBLE

SUMVISIBLE(rgeValues)
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.
* The built-in SUM function will always include hidden cells.
* You can use the add-in SUMIFSVISIBLE returns the total from the visible, non blank cells that satisfies multiple conditions.
* Similar to the AVERAGEVISIBLE, COUNTVISIBLE, MAXVISIBLE and MINVISIBLE add-in functions.

MORE FUNCTIONS
MEDIANVISIBLE* function to return the number in the middle from the visible, non blank cells.