SumIF

Excel SUMIF Function

Purpose

Sum numbers in a range that meet supplied criteria Return value The sum of values supplied.

Syntax

=SUMIF (range, criteria, [sum_range])

Arguments

range - Range to apply criteria to. criteria - Criteria to apply. sum_range - [optional] Range to sum. If omitted, cells in range are summed.