AverageIfS

Syntax

AverageIfS(AverageRange, Range1, Criteria1, Range2, Criteria2, …)

Parameters

AverageRange. The actual cells, for which average is calculated.

Range1, Range2, …, RangeN. The range of cells checked for correspondence to the specified condition.

IMPORTANT. Each Range range must correspond in size and form to the AverageRange range.

Criteria1, Criteria2, …, CriteriaN. The condition that determines the cells, for which average is calculated. The condition may be a number, expression, cell hyperlink, text, or function.

NOTE. All text conditions and conditions with logical mathematical characters must be enclosed in double quotation marks (").

Description

It returns the average of cells that satisfy the specified set of conditions.

Example

Formula	Result	Description
=AverageIfS(A0:A3, B0:B3, ">0", C0:C3, "<0")	-1	Average of the array located in the A0, A1, A2, A3 cells, provided that values in the B0:B3 cell range must be positive, and values in the C0:C3 cell range must be negative. The A0:A3 range contains the following numbers: -2, 6, 4, -8; the B0:B3 range contains the following numbers: -6, 4, -9, 5; the C0:C3 range contains the following numbers: 2, -8, -3, -7.