SUMVISIBLE

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

unitThe 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??




THE BUSINESS

Better Solutions Ltd

London, N20 8LU

Incorporated 2004

VAT No 840-0533-67

Company No 05155080