How To Use SUMIF?

Use `SUMIF(range, criteria, [sum_range])`

Select the range to check against the condition

Enter the condition or criteria

Optionally select the range to sum

If `sum_range` is omitted, Excel sums the cells in `range`

Use text criteria like `”Apples”`

Use comparison criteria like `”>10″`

Use cell references for criteria like `A1`

Use wildcards like `”*text*”` for partial matches

Use `=SUMIF(A1:A10, “Apples”, B1:B10)`

Use `=SUMIF(A1:A10, “>10”, B1:B10)`

Suggested for You

Trending Today