averageifs

Mean of numbers meeting multiple criteria.

Syntax

v = averageifs(average_range, criteria_range1, criteria1, ...)

Description

Averages cells in average_range for which every corresponding criteria_range_n matches the corresponding criteria_n. Multiple criteria pairs are combined with logical AND.

Example

averageifs(B1:B100, A1:A100, '>0', C1:C100, 'red')

See also

• averageif — Mean of numbers in a range that meet a criterion.
• countifs — Count cells meeting multiple criteria.
• sumifs — Sum cells meeting multiple criteria.