Average of range, if each item in range is > some value

[dpawson]

A range of numbers, B2:B28.
I want to calculate the average of that range only if each element is > 10.0
average(B2:B2… if $x > 10) or something?
Suggestions please

[PKG]

AVERAGEIF function

[dpawson]

Thanks, my case averageif(B2:B28, “>10.0”)

[Lupp]

This doesn’t check if each item in the range is greater than 10. It restricts the calculation of the average to the items that are. All the others are ignored then.

[dpawson]

@Lupp that was just what I wanted thanks. I.e. the average of all items > 10 in the range, ignoring those with value less than or equal to 10