Excel SUMIF Function
Is Draft
November 20, 2018
Description
The Excel SUMIF function is similar to the SUM function except it takes in a condition criteria. The SUMIF function will use the to determine whether the value will be counted in the SUMIF function.
Usage
=SUMIF(sum_range, criteria, criteria_range)Parameters
| Name | Required | Description |
|---|---|---|
| sum_range | Yes | details |
| criteria | Yes | details |
| criteria_range | No | details |
Examples
No. 1
=SUMIF(B:B, ">=50")No. 2
=SUMIF(B:B, "<50", C:C)Demo
add video here
Official Article
Microsoft Excel SUMIF Function