Description of formula:

Calculates the arithmetic mean of the values from a specified range, which meet the criteria.

First parameter is an array of values, to which the condition is applied. If some element satisfies the condition, corresponding value from

The condition is an expression, which returns a logical value (true / false). You can use there any formula, comparison operator and join several criteria with and and or. Use value keyword to refer to evaluated element from the

Calculates the arithmetic mean of the values from a specified range, which meet the criteria.

First parameter is an array of values, to which the condition is applied. If some element satisfies the condition, corresponding value from

*result_values*array is included in the calculations. Both arrays must have the same number of elements. The third parameter of the formula is optional – if you do not specify it, values from*query_values*array will be used both for checking the condition and for calculating the average.The condition is an expression, which returns a logical value (true / false). You can use there any formula, comparison operator and join several criteria with and and or. Use value keyword to refer to evaluated element from the

*query_values*array.Syntax:

averageif(query_values, condition, [result_values])

averageif(query_values, condition, [result_values])

Parameters:

query_values

(type: array of values of any type) Values to which the condition is applied

condition

(type: Logical value) Logical expression, defining which elements will be used for calculations

result_values

(type: array of Numbers) (optional parameter) Values to be used in calculations (if you want to use another values than passed in the first parameter)

Returned type:

Number

Examples:

=averageif(A1:A5,value>100)

=averageif(A1:A5, value>100, B1:B5)

=averageif(section1.B, value=’product1’, section1.A)

=averageif(A, abs(value)/2>section1.A1, C)

=averageif(A, value>20 and value<50)

=averageif(A1:A5,value>100)

=averageif(A1:A5, value>100, B1:B5)

=averageif(section1.B, value=’product1’, section1.A)

=averageif(A, abs(value)/2>section1.A1, C)

=averageif(A, value>20 and value<50)

Remarks:

Empty cells are considered as 0 in calculations.

Empty cells are considered as 0 in calculations.

## 0 Comments