SUMIF formula error

I have various formulas like SUMIF(C11,“Freight”,I11) set up, they have been working fine. But recently I added formulas and lookups further down the sheet and these sumifs started playing up.
Where the sum should be 16.50 I am getting 580 for example.
If I go in and manually update the formula in the backend it works fine, until I make changes on the sheet, then it finds some random number again…


Would you please click “Need Help” at upper right corner in your database to submit a support ticket with detailed information of the issue, e.g. on which sheet (sheet url), with which field you have applied the formula to that is not working correctly, and click “Grant Access Right to Ragic Support Team” so that we can look into your database?