SUMVISIBLEIFS

Returns the total from the visible, non blank cells that satisfies multiple conditions.

??	(Optional) The unit to use for 'single' decimal numbers.

* This function excludes hidden cells.
* You can use the SUMIFS function to include hidden cells.
* The equivalent VBA function is SUMVISIBLEIFS

	A
1	??