How to Use SUMIF in Google Sheets

The SUMIF function in Google Sheets allows users to sum specific cells within a list. SUMIF is able to use exactly one criterion to determine if a value within a list should be summed or not.

So How Does It Work?

The SUMIF function requires at least 2 arguments to perform. A third argument may be, and usually is, used. Below is the formula for the SUMIF function and a breakdown of each of its arguments.

Formula: =SUMIF(range, criterion, [sum_range])

(Required) The Range is the set of cells that Google Sheets will check to determine if its corresponding cell in the Sum_Range should be summed. The Range and Sum_Range cells share the same row number.

Criterion

(Required) The Criterion is the value that Google Sheets checks in the Range to determine if it should be summed. The criterion must match the type of value of the range: number or text.

Sum_Range

(Optional) The Sum_Range is the range of cells summed if the criterion is met. If the set of cells is the same as the Range, it can be left blank. However, most times these will be different.