averageif
Mean of numbers in a range that meet a criterion.
Syntax
Section titled “Syntax”v = averageif(range, criteria, sum_range)Description
Section titled “Description”Averages cells in sum_range (or range if sum_range is omitted) for which the corresponding cell in range meets criteria. criteria is a string like '>10', 'apples', '<>0'.
Example
Section titled “Example”averageif(A1:A10, '>0') % mean of positive valuesSee also
Section titled “See also”averageifs— Mean of numbers meeting multiple criteria.average— Arithmetic mean of numeric arguments (Excel-compatible).countif— Count cells in a range that meet a criterion.sumif— Sum cells in a range that meet a criterion.