How to Use SUMIF in Google Sheets

SUMIF adds up numbers that meet one condition — like summing only 'Paid' invoices. Here's how it works, with examples, and a free tool to generate it for your exact columns.

The syntax

=SUMIF(range, criterion, sum_range)

range = cells to check · criterion = the condition · sum_range = cells to add.

Example

Sum column B where column A is 'Paid':

=SUMIF(A:A, "Paid", B:B)

Multiple conditions

For more than one condition, use SUMIFS:

=SUMIFS(B:B, A:A, "Paid", C:C, "West")

⚡ Generate a formula — free, no signup

Describe what you want in plain English. Get the exact Google Sheets / Excel formula.