AverageIf

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 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:
avaregeif(query values, condition)
Parameters:
query values
(type:array of numbers) values to which the condition is applied
condition
(type:logical value) logical expression, defining which elements will be used for calculations
or
Syntax:
avarageif(query_values, condition, result_values)
Parameters:
query_values
(type:array of values of any type) values to which the condition is applied
warunek
(type:logical value) logical expression, defining which elements will be used for calculations
result_values
(type: array of Numbers) 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)
Remarks:
Empty cells are considered as 0 in calculations.
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk