AVERAGEIFS

Averages cells matching multiple conditions.

Excel: Not checked yet
Google Sheets: Not checked yet
Returns: Number

Examples

=AVERAGEIFS(B1:B3, A1:A3, ">15")

	A	B
1	10	2
2	20	4
3	30	6

Result 5

Syntax

AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2…], [criteria2…])

average_range: range required
criteria_range1: range required
criteria1: any required
criteria_range2…: range optional
criteria2…: any optional

Errors

#DIV/0!: =AVERAGEIFS(A1:A3, A1:A3, TRUE)

AVEDEVAverage of absolute deviations from the mean. AVERAGE.WEIGHTEDAverage of values weighted by a second range. AVERAGEAAverages values including text and logicals. AVERAGEIFAverages cells that match a condition. BETA.DISTBeta distribution. BETA.INVInverse of the beta distribution.