SUMIF formula

The SUMIF function in Google Sheets is designed to sum numeric data based on one condition.

How to use?

SYNTAX: =SUMIF(range, criterion, [sum_range])
Range (required) - the range of cells that should be evaluated by criterion.
Criterion (required) - the condition to be met.
Sum_range (optional) - the range in which to sum numbers. If omitted, then range is summed.

Practice sheet

The below sheet is view only mode, please make a copy to practice.

Copy of Sumif Function

Make a copy

Page updated

Google Sites

Report abuse