SUMIF function


DESCRIPTION:

Add cells specified by a given condition or criteria.

 

SYNTAX:

=SUMIF( range, criteria[sum_range] )

 

REQUIRED ARGUMENTS:

range

The range of cells that you want to apply the criteria against.

criteria

The criteria used to determine which cells to add.

 

OPTIONAL ARGUMENTS:

[sum_range]

The cells to add together. If sum_range is omitted, the cells in range are added together instead.