Furmula oddity

I am encountering a bit of an oddity.

I am, and have been using several sum- and count-ifs formulas for a time, but when the new year rolled around, decided to improve some of the sheet.

That all being said, the issue started after this. A specific set of my count and sum if functions started returning error values.

I analysed them, they seemed fine, and then selected them and hit enter. Problem over in that cell, as suddenly the correct value is returned.
But that’s just it, I know the formulas are correct and working, as, if I select and hit enter on them individually, they return the right value. However, every time I close the sheet and re-open, all the values are showing error again.

I am perplexed. Did I inadvertently change a setting somewhere when I rebuilt the worksheet that is preventing the formulas from resolving correctly? As, like I said before, the formulas are fine, the data they are resolving, is fine. Just does not seem to calculate when I open the sheet. Refreshing does not help either.

Maybe your formulas setting turn on to "Manual", change to "Automatic"

First Step: Click on Formulas Tab on Excel

First Two: Look at Calculation Options, an then choose "Automatic"

BINGO!

Did not even know that exsisted. Thanks a ton Azumi!