SUMVISIBLE

Returns the sum of values from the visible, non blank cells.

unit

The unit

Remarks

* You can use the SUM function to include hidden cells.
* This is just a dedicated function, you could use the SUMVISIBLEIFS function with a single argument.
* The equivalent VBA function is SUMVISIBLE

	A
1	??