SUMIF / SUMIFS Formula Generator
Describe what you want to add up and under what conditions, in plain English, and get a ready-to-use SUMIF or SUMIFS formula for Excel or Google Sheets.
5 free tries without an account
SUMIF and SUMIFS syntax
=SUMIF(range, criteria, [sum_range]) =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2, ...])Use SUMIF for a single condition, SUMIFS when you need two or more conditions to all be true. Note the argument order flips: SUMIF puts sum_range last, SUMIFS puts it first. Formulon figures out which one you need and gets the argument order right automatically.
Examples
Sum sales for one region
=SUMIF(B:B,"West",C:C)Checks every cell in column B, and for each one that equals "West", adds the corresponding value from column C to the total.
Sum revenue for a region AND a specific month
=SUMIFS(D:D,B:B,"West",C:C,"Jan")Sums column D, but only for rows where column B equals "West" AND column C equals "Jan" — both conditions must be true.
Frequently asked questions
What's the difference between SUMIF and SUMIFS?
SUMIF sums a range based on a single condition. SUMIFS sums a range based on multiple conditions that all have to be true at once (an AND). The argument order also differs: SUMIF is (range, criteria, sum_range), SUMIFS is (sum_range, range1, criteria1, range2, criteria2, ...).
Can I sum based on a date range?
Yes, with SUMIFS: use two criteria on the same date column, e.g. ">=" and "date and "&B1 as one criterion and "<=" and "date and "&B2 as another, to sum everything between two dates.
Does SUMIF work the same in Google Sheets?
Yes, the syntax and argument order are identical in Excel and Google Sheets for both SUMIF and SUMIFS.
Why is my SUMIF returning 0?
The most common causes are: the criteria text doesn't exactly match the cells (extra spaces, wrong case-sensitive punctuation), the range and sum_range aren't the same size, or the numbers you're trying to sum are actually stored as text.
Don't want to write it by hand?
Describe what you need in plain English and get a ready-to-use formula in seconds.
Try the formula generator