AVERAGEVISIBLEIFS
AVERAGEVISIBLEIFS(average_range, criteria_range1, criteria1, criteria_range2, criteria2)
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 caused by AutoFilter, Grouping or that have been Manually Hidden.
* You can use the built-in AVERAGEIFS function to include hidden cells.
* This is similar to the COUNTVISIBLEIFS, MAXVISIBLEIFS, MINVISIBLEIFS and SUMVISIBLEIFS functions.
* This page has the equivalent VBA function.
|
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext