Fix SUMIFS Returning Zero in Excel for the Web
Question details
Find out why a SUMIFS formula returns zero in Excel for the web when it works in desktop Excel.

- 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.
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.
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.
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.
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.
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.
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).
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.

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.

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.




