SUMIF & COUNTIF Formula Generator

SUMIF adds up numbers that meet one condition; COUNTIF counts cells that meet one condition. Their plural cousins SUMIFS and COUNTIFS handle multiple conditions. Fill in the range and criteria below to generate the correct formula for Excel or Google Sheets.

It's free, browser-based, and requires no account.

Operation

Sum range

The numbers to add up

Criteria range 1

Where to test the condition

Criteria 1

In quotes, e.g. ">100" or "Marketing"

Criteria range 2 (optional)

Add a second condition → SUMIFS/COUNTIFS

Criteria 2 (optional)

SUMIF formula

=SUMIF(A2:A100, ">100", B2:B100)

SUMIF vs COUNTIF vs SUMIFS

Use SUMIF to total values matching one condition: =SUMIF(range, criteria, [sum_range]).

Use COUNTIF to count cells matching one condition: =COUNTIF(range, criteria).

Use SUMIFS when you have two or more conditions: =SUMIFS(sum_range, criteria_range1, criteria1, ...). Note the argument order flips — the sum range comes first in SUMIFS.

Writing criteria correctly

Text and comparison criteria go in quotes: "Marketing", ">100", "<=2024-01-31".

To reference a cell in the criteria, join it with & — for example ">"&B1.

Wildcards work in text criteria: * matches any number of characters, ? matches a single character.

Frequently asked questions

What is the difference between SUMIF and SUMIFS?

SUMIF handles a single condition and puts the sum range last. SUMIFS handles multiple conditions and puts the sum range first. If you need more than one criterion, use SUMIFS.