# SUMIFS formula generator

> Describe what you need and get a SUMIFS formula for Excel and Google Sheets, run on real data before you copy it. Plus 8 tested SUMIFS examples.

Source: https://spreadsheetpractice.com/tools/formula-generator/sumifs · Updated October 29, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

SUMIFS adds the values where every condition is true: East region widget sales, February revenue, large orders from one customer.

Describe the task at [SUMIFS formula generator](https://spreadsheetpractice.com/tools/formula-generator/sumifs) and get a SUMIFS formula for Excel and Google Sheets, tested on real data.

## Tested SUMIFS examples

### Sum if a cell is blank

`=SUMIFS(B2:B8,C2:C8,"")`

Excel. Result on the sample sheet: $6,835. [See it and try it](https://spreadsheetpractice.com/formulas/sum-if-blank)

### Sum if a cell is not blank

`=SUMIFS(B2:B8,C2:C8,"<>")`

Excel. Result on the sample sheet: 153.75. [See it and try it](https://spreadsheetpractice.com/formulas/sum-if-not-blank)

### Sum with multiple criteria in Excel (SUMIFS)

`=SUMIFS(D2:D11,B2:B11,G1,C2:C11,G2)`

Excel. Result on the sample sheet: $1,005. [See it and try it](https://spreadsheetpractice.com/formulas/sum-with-multiple-criteria)

### Calculate month-to-date (MTD) sales

`=SUMIFS(C2:C10,A2:A10,">="&EOMONTH(F1,-1)+1,A2:A10,"<="&F1)`

Excel. Result on the sample sheet: $10,240. [See it and try it](https://spreadsheetpractice.com/formulas/month-to-date-total)

### Fix #VALUE! in SUMIFS

`=SUMIFS(C2:C8,B2:B8,F1)`

Excel. Result on the sample sheet: $2,965. [See it and try it](https://spreadsheetpractice.com/formulas/sumifs-value-error)

### Show a blank instead of 0

`=LET(t,SUMIFS($C$2:$C$7,$B$2:$B$7,E2),IF(t=0,"",t))`

Excel. Result on the sample sheet: 5 rows (F2:F6). [See it and try it](https://spreadsheetpractice.com/formulas/show-blank-instead-of-zero)

### Why does SUMIFS return 0 with two criteria on the same column

`=SUM(SUMIFS(C2:C8,B2:B8,E2:E3))`

Excel. Result on the sample sheet: $3,345. [See it and try it](https://spreadsheetpractice.com/formulas/sumifs-or-on-the-same-column)

### Reference a spilled range

`=SUMIFS(C2:C11,B2:B11,D2#)`

Excel. Result on the sample sheet: 4 rows (E2:E5). [See it and try it](https://spreadsheetpractice.com/formulas/reference-a-spilled-range)

## Questions

### What does the SUMIFS formula generator do?

You describe the task in plain English, and it writes the formula, using SUMIFS where that's the right tool, for your table or a sample one. The formula is run in our engine in Excel and Google Sheets mode before you see it, so you get its result, not just a guess.

### What does SUMIFS do?

SUMIFS adds the values where every condition is true: East region widget sales, February revenue, large orders from one customer.

### Can I learn to write SUMIFS formulas myself?

Yes. Each example below opens a page where you try the formula in a live grid and it's checked as you go, and the SUMIFS function page has a practice exercise.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
