▲ 1 r/googlesheets
SUMIF and SUMIFS formulas not updating
I created a budgeting sheet in April which worked fine all of last month, and now I've copied it for May and initially this copy was also working. However, a few days ago I noticed that formulas showing the total amount spent, using SUMIF and SUMIFS, aren't updating any more.
Everything that should be numerical data has been formatted as such. Additionally, from the Settings I've made sure Iterative calculation is off, and the recalculation setting is set to "On change and every minute". I've also tried creating a new file and copying the contents of the original manually there, and still it doesn't work. Any ideas?
Formula for mandatory expenses (\"Pakollinen\")
u/Illustrious-Fee1784 — 3 days ago