SUMIFS function


DESCRIPTION:

Sums cells that match multiple criteria.

 

SYNTAX:

=SUMIFS( sum_range, criteria_range1, criteria1, [criteria_range2], [criteria2], ... )

 

REQUIRED ARGUMENTS:

sum_range

The range to be summed.

criteria_range1

The first range to evaluate.

criteria1

The criteria to use on criteria_range1.

 

OPTIONAL ARGUMENTS:

[criteria_range2]

The second range to evaluate.

[criteria2]

The criteria to use on criteria_range2.