SUMIF Function

SUMIF

On the Base of Criteria "SUMIF" Adds all number in the given range 

Syntax  

SUMIF( range, criteria, sum-range)

Examples 

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

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

=SUMIF(A2:A6, 2003, C2:C6)
Result: 7.2

=SUMIF(A2:A6, ">=2001", C2:C6)
Result: 12.6