SumIfS

Syntax

SumIfS(SumRange, Range1, Criteria1, Range2, Criteria2, …)

Parameters

SumRange. Actual cells for summation.

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 SumRange range.

Criteria1, Criteria2, …, CriteriaN. The condition that determines summed cells. 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 sum of numbers in the specified cell range that satisfy the specified set of conditions.

Example

Formula	Result	Description
=SumIfS(A0:A3, B0:B3, "<0", C0:C3, "<0")	4	The sum of values of the array located in the A0, A1, A2, A3 cells provided that values in the B0:B3 and C0:C3 cells 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.