AVERAGEIFSVISIBLE
AVERAGEIFSVISIBLE(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.
* The built-in AVERAGEIFS function will always include hidden cells.
* You can use the add-in AVERAGEVISIBLE function to return the average value from the visible, non blank cells.
* Similar to the COUNTIFSVISIBLE, MAXIFSVISIBLE, MINIFSVISIBLE and SUMIFSVISIBLE add-in functions.
 |
MORE FUNCTIONS
* AVERAGEVISIBLEA* function to returns the average value from the visible, non blank cells.
* AVERAGETOP* function to return the average from a range of values only considering the top "x" values
* MEDIANIFSVISIBLE* function to return the number in the middle from only the visible, non blank cells that satisfy multiple conditions.
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext