Use: Adds the cells specified by given condition(s)

The Syntax of SUMIF Function is as under: = SUMIF(range, criteria, [sum_range])

Examples:

  • Specific Value

=SUMIF(A2:A6, D2, C2:C6)

=SUMIF(A:A, D2, C:C)

*D2 = criteria 

  • Value(s) following criteria 

=SUMIF(A2:A6, “>=2001”, C2:C6)

*Criteria is greater than or equal to 2001

Advertisements