Formula Errors

Fix SUMIFS Returning Zero in Excel for the Web

Emma BrownEmma Brown Nov 18, 2026 868 views

Question details

Find out why a SUMIFS formula returns zero in Excel for the web when it works in desktop Excel.

Fix SUMIFS Returning Zero in Excel for the Web
Product
Microsoft Excel for the web
Device & OS
not provided
Scenario
A user opens a workbook in Excel for the web and needs a SUMIFS formula to calculate the same result as in desktop Excel.
Observed behavior
The SUMIFS formula returns zero in Excel for the web, although it returns a result in desktop Excel.
Before you start

Open the workbook in Excel for the web and locate the exact SUMIFS formula and its referenced ranges. If possible, prepare a small sample containing the formula and a few representative rows for testing.

Solution 1Recommended

Check the SUMIFS Formula, Criteria, and Source Data

Use these checks to identify mismatched criteria, text values, or inaccessible references that may cause a zero result.

Excel for the web uses the same SUMIFS syntax as desktop Excel. A zero result often means no rows match the criteria or the values being summed are not recognized as numbers.

1
Inspect the formula

Select the result cell and review the formula bar. Check the syntax =SUMIFS(sum_range, criteria_range1, criteria1, ...) and confirm that each range points to the intended cells.

2
Align the ranges

In the formula bar, check that the sum range and every criteria range cover corresponding rows and have the same dimensions. For example, use C2:C100 with A2:A100, rather than C2:C100 with A1:A100.

3
Test the criteria

In an empty cell, enter a COUNTIFS formula using the same criteria ranges and criteria, such as =COUNTIFS(A2:A100,"East"). If it returns zero, inspect the source text for spelling differences or extra spaces; use =LEN(A2) and =LEN(TRIM(A2)) to help spot extra spaces.

4
Check dates and numbers

In an empty cell, use =ISNUMBER(B2) to test a date cell or =ISNUMBER(C2) to test a value being summed. If a value is stored as text, convert it to a real date or number; for date criteria, use an unambiguous expression such as ">="&DATE(2025,1,1).

5
Verify references and retest

Select each referenced sheet or range in the workbook and confirm that the expected data is available. If the formula refers to another workbook, check that the link and its data are accessible in Excel for the web, then test the formula with a few rows in a small sample workbook.

Check the SUMIFS Formula, Criteria, and Source Data
When asking for help: Share the exact formula and, if appropriate, a small sample workbook through a OneDrive link so others can test the references and data.
Free Microsoft Office alternative

Work With SUMIFS Formulas in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel workbooks in WPS Spreadsheets to review data and work with SUMIFS formulas while moving between office suites.

Review SUMIFS formulas and their source ranges in WPS SpreadsheetsOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Does SUMIFS use different syntax in Excel for the web?

No. Excel for the web uses the same SUMIFS syntax as desktop Excel: =SUMIFS(sum_range, criteria_range1, criteria1, ...). Check the formula bar for incorrect ranges or criteria.

How can I tell whether any rows match my criteria?

Enter a COUNTIFS formula in an empty cell using the same criteria ranges and criteria as SUMIFS. A zero count means no rows match all the conditions.

Can numbers stored as text cause SUMIFS to return zero?

Yes. SUMIFS may not add text values in the sum range. Test a source cell with =ISNUMBER(C2) and convert text values to numbers where needed.

How should I enter a date criterion in SUMIFS?

Make sure the source dates are real Excel dates, then use an unambiguous criterion such as ">="&DATE(2025,1,1). You can test a date cell with =ISNUMBER(B2).

What should I check if the formula references another workbook?

Check the external link and confirm that the referenced data is accessible in Excel for the web. You can also test the formula with local data in a small sample workbook.