AVERAGEVISIBLEIFS

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

average_range	The actual cells to average.
criteria_range1	The range of cells you want evaluated.
criteria1	The expression that contains the criteria.
criteria_range2	(Optional) The range of cells you want evaluated.
criteria2	(Optional) The expression that contains the criteria.

Remarks

* This function excludes hidden cells.
* There is no AVERAGEVISIBLE function because this function can be used with one argument.
* You can use the AVERAGEIFS function to include hidden cells.
* The equivalent VBA function is AVERAGEVISIBLEIFS

	A
1	??