SUMIFS not working after certain dates


I have been working on daily spent in Sheet 1 and that spent is converted to weekly spent directly using SUMIFS function, but after certain weekly dates the Total Spent SUM is been showing wrong.

Sheet 1 data

Sheet 2 Data

The formula used is


The spent data is showing wrong from 15/01/2024.

Thanks in advance for the help


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!