AVERAGEIF
Syntax
averageif([Range], Condition)Arguments
Example
averageif([Column1],[Column2], “>10000”)Excel equivalent
Last updated
Was this helpful?
The AVERAGEIF function returns the average of the filtered values that satisfy the given condition.
averageif([Range], Condition)Range – List of values. This is a required argument.
Condition – Condition to be checked. This is a required argument.
averageif([Column1],[Column2], “>10000”)Returns the average of Column1 and Column2 if they are above 10000
Last updated
Was this helpful?
Was this helpful?