Excel · ChatGPT

SUMIFS Returning 0 in Excel? Fix It with ChatGPT

Q: Why does my SUMIFS return 0?

A SUMIFS formula can return 0 when its criteria match no rows, dates are stored as text instead of real Excel dates, values in the sum range are stored as text, or hidden spaces prevent an exact text match. A range-size mismatch is different: SUMIFS returns #VALUE! when its range arguments do not have matching dimensions.

Q: Can SUMIFS handle OR conditions?

Yes. SUMIFS combines its criteria with AND, so a clear way to handle OR is to add separate SUMIFS together. In current Excel you can also use an array constant with SUM(SUMIFS(...)) for compact OR logic.

Q: How do I use date ranges in SUMIFS?

Wrap the operator in quotes and use & to join the date: use >="&DATE(2026,1,1) or >="&A1 to sum values on or after a date.

Paste your broken SUMIFS into ChatGPT with the prompt below. It will identify the problem and give you a corrected formula.

Choose your situation — copy the prompt:

I need a SUMIFS formula. Here's what I want:
[describe in plain English, e.g. "Sum Revenue where Region is 'North',
Product is 'Widget Pro', and Date is between 1 Jan 2026 and 31 Mar 2026"]

My data is on sheet [name]. Column structure:
- Sum range: column D (Revenue)
- Criteria 1: column A (Region)
- Criteria 2: column B (Product)
- Criteria 3: column C (Date)

Data runs from row 2 to row [last row].
Please write the SUMIFS with absolute references so I can copy it safely.

Replace the bracketed parts with your real columns, then paste the prompt into ChatGPT.

My SUMIFS is returning 0 even though there should be matches.

Here's the formula:
[paste formula]

Here are 3 sample rows from my data:
[paste rows]

The expected result for these rows is [expected value].
Please tell me what's wrong and give me the corrected formula.

Paste 3 real rows — ChatGPT usually spots the issue in one pass.

I need to sum Revenue where Region is either 'North' OR 'South'.
How should I structure this with SUMIFS?
Revenue is column D, Region is column A, data from row 2 to 500.

ChatGPT will write two SUMIFS added together — one per OR condition.

Before — criteria are clear, but no formula exists

Sales

	A	B	C	D	F
1	Region	Product	Date	Revenue	Q1 total
2	North	Widget Pro	15/01/2026	£1,200	No formula
3	South	Widget A	20/01/2026	£850
4	North	Widget Pro	03/02/2026	£2,100
5	East	Widget A	18/02/2026	£940
6	North	Widget Pro	05/03/2026	£1,800
7	South	Widget B	22/03/2026	£1,140

Need: Region = North, Product = Widget Pro, Date from 1 Jan through 31 Mar 2026. The three matching revenues are £1,200, £2,100 and £1,800.

After — SUMIFS returns the verified Q1 total

Sales

=SUMIFS($D$2:$D$500,$A$2:$A$500,"North",$B$2:$B$500,"Widget Pro",$C$2:$C$500,">="&DATE(2026,1,1),$C$2:$C$500,"<="&DATE(2026,3,31))

	A	B	C	D	F
1	Region	Product	Date	Revenue	Q1 total
2	North	Widget Pro	15/01/2026	£1,200	£5,100
3	South	Widget A	20/01/2026	£850
4	North	Widget Pro	03/02/2026	£2,100
5	East	Widget A	18/02/2026	£940
6	North	Widget Pro	05/03/2026	£1,800
7	South	Widget B	22/03/2026	£1,140

Verified result

£1,200 + £2,100 + £1,800 = £5,100 ✓
All sum/criteria ranges use rows 2:500.

Before — SUMIFS returns 0 because dates are stored as text

Sales

=SUMIFS($D$2:$D$100,$A$2:$A$100,"North",$B$2:$B$100,"Widget Pro",$C$2:$C$100,">="&DATE(2026,1,1),$C$2:$C$100,"<="&DATE(2026,3,31))

	A	B	C	D	F
1	Region	Product	Date	Revenue	Result
2	North	Widget Pro	'15/01/2026	£1,200	£0
3	North	Widget Pro	'03/02/2026	£2,100
4	North	Widget Pro	'05/03/2026	£1,800

The formula syntax is valid, but C2:C4 contains text strings, not Excel date serial values. Numeric date criteria therefore match none of these rows.

After — convert C to real dates; same SUMIFS returns £5,100

Sales

=SUMIFS($D$2:$D$100,$A$2:$A$100,"North",$B$2:$B$100,"Widget Pro",$C$2:$C$100,">="&DATE(2026,1,1),$C$2:$C$100,"<="&DATE(2026,3,31))

	A	B	C	D	F
1	Region	Product	Date	Revenue	Result
2	North	Widget Pro	15/01/2026	£1,200	£5,100
3	North	Widget Pro	03/02/2026	£2,100
4	North	Widget Pro	05/03/2026	£1,800

ChatGPT's diagnosis

Cause: Date cells were text, not real Excel dates.
Fix the source dates first; the SUMIFS formula itself does not need to change.
£1,200 + £2,100 + £1,800 = £5,100 ✓

Before — need North + South but SUMIFS combines criteria as AND

Region	Rep	Product	Revenue	North OR South?
North	A. Reid	Widget Pro	£1,200	Include
East	D. Lane	Widget A	£940	Exclude
South	B. Shaw	Widget Pro	£2,100	Include
West	E. Kim	Widget B	£780	Exclude
North	C. Fox	Widget Pro	£1,800	Include
South	B. Shaw	Widget A	£1,140	Include

          Writing "North" OR "South" directly inside SUMIFS is not valid syntax
          ↑ Expected total: £1,200 + £2,100 + £1,800 + £1,140 = £6,240

After — ChatGPT adds two SUMIFS, one per OR condition

Region group	Product	SUMIFS result	Combined
North only	All products	£3,000	£6,240 ✓
South only	All products	£3,240	£6,240 ✓
East	Widget A	£0 (excluded)	—
West	Widget B	£0 (excluded)	—

ChatGPT's formula

=SUMIFS($D$2:$D$500,$A$2:$A$500,"North")
+SUMIFS($D$2:$D$500,$A$2:$A$500,"South")
North: £1,200+£1,800 = £3,000
South: £2,100+£1,140 = £3,240
Total: £6,240 ✓

How to Fix SUMIFS Returning 0 in Excel

Why SUMIFS returns 0 — 4 common causes

Criteria do not match

A criterion is valid but matches no rows — for example "North " vs "North"

Check first

Date stored as text

Cell looks like 15/01/2026 but is TEXT, so numeric date criteria do not match

This example

Sum values stored as text

Matching rows exist, but values in the sum range are text and are not added as numeric amounts

Data issue

Text criterion entered incorrectly

Text criteria should be supplied as text, e.g. "North" or a cell reference

Formula issue

Build a SUMIFS from scratch — 5 steps

Describe it in plain English

Write one sentence: "I want to sum the Revenue column where Region is North, Product is Widget Pro, and Date is between 1 Jan and 31 Mar." That sentence becomes your prompt.

Paste 3–4 sample rows

Tell ChatGPT your column structure and paste a few real rows. ChatGPT can see the date format, text casing, and number format — which can help catch common problems before you build the formula.

Get the formula with absolute references

Ask ChatGPT to use $A$2:$A$500 style references so the formula is safe to copy across rows or columns.

Test on one row first

Verify the formula on a row where you already know the correct answer before applying it across the whole report.

Debug if it still returns 0

Paste the broken formula and 3 sample rows into ChatGPT. It can help identify non-matching criteria, hidden spaces, text-formatted dates, or text values in the sum range.

Tip: Whole-column references such as $A:$A can be useful when the row count changes, but use whole-column references consistently for the sum range and every criteria range. They can be slower in large workbooks.

Frequently Asked Questions

Why does my SUMIFS return 0?

A zero result usually means the formula found no numeric values that satisfy all criteria. Check for text dates, text-formatted values in the sum range, hidden spaces, or criteria that simply do not match. If the sum range and criteria ranges are different sizes, that is a different error: Excel returns #VALUE!.

Can SUMIFS handle OR conditions?

SUMIFS combines its criteria with AND, so the clearest way to handle OR is to add separate SUMIFS together with +: =SUMIFS(E:E,A:A,"North")+SUMIFS(E:E,A:A,"South"). In current Excel you can also use an array constant for a single compact formula: =SUM(SUMIFS(E:E,A:A,{"North","South"})). Ask ChatGPT for the OR prompt above and it will write either version for you.

How do I use date ranges in SUMIFS?

Wrap the operator in quotes and join it to the date with &: use ">="&DATE(2026,1,1) or ">="&A1. Make sure the date column contains real Excel dates — not text that looks like a date.

SUMIFS vs SUMIF — which should I use?

Use SUMIFS even when you only have one condition. The argument order is more consistent and it's easier to add more criteria later without rewriting the formula.

SUMIFS Returning 0 in Excel? Fix It with ChatGPT

How to Fix SUMIFS Returning 0 in Excel

Describe it in plain English

Paste 3–4 sample rows

Get the formula with absolute references

Test on one row first

Debug if it still returns 0

Frequently Asked Questions

Related Excel Workflows