Formula Fix Detected issues Mixed locale separators – semicolons used instead of commas (Excel default is commas in English locale). Date string in the condition is not wrapped in quotes properly or interpreted as a date value. SUMIFS expects proper syntax: SUMIFS(sum_range, criteria_range1, criteria1, ...). Fixed formula (Excel) excel Copier Modifier =SUMIFS(A:A, B:B, ">=01/05/2025") Google Sheets variant gs Copier Modifier =SUMIFS(A:A, B:B, ">=01/05/2025") Why this works • Commas are used instead of semicolons for correct function argument separation in English Excel. • Date condition is enclosed properly in double quotes to be treated as a string. • Syntax matches the expected structure of the SUMIFS function. Tips • In French/European locales, semicolons (;) may be used instead of commas (,). Adjust according to your Excel language settings. • For dynamic date filtering, consider using TODAY() or referencing a cell instead of hardcoding a date. • Excel treats date strings in formulas as text unless explicitly converted—ensure proper formatting or use DATE(2025,5,1) for precision.