I do have a pretty big formula that looks like that:
=SUMIFS($Research.$M$1:$M$100,$Research.$L$1:$L$100,AF25,$Research.$B$1:$B$100,"No")
+SUMIFS($Research.$O$1:$O$100,$Research.$N$1:$N$100,AF25,$Research.$B$1:$B$100,"No")
+SUMIFS($Foundry.$J$1:$J$100,$Foundry.$I$1:$I$100,AF25,$Foundry.$B$1:$B$100,"No")
+SUMIFS($Foundry.$L$1:$L$100,$Foundry.$K$1:$K$100,AF25,$Foundry.$B$1:$B$100,"No")
+SUMIFS($Foundry.$N$1:$N$100,$Foundry.$M$1:$M$100,AF25,$Foundry.$B$1:$B$100,"No")
+SUMIF($AC$38:$AC$51,AF25,$AD$38:$AD$51)
Every once in a while it reverts and reference the sheets twice (making the formula harder to read):
=SUMIFS($Research.$M$1:$Research.$M$100,$Research.$L$1:$Research.$L$100,AF4,$Research.$B$1:$Research.$B$100,"No")
+SUMIFS($Research.$O$1:$Research.$O$100,$Research.$N$1:$Research.$N$100,AF4,$Research.$B$1:$Research.$B$100,"No")
+SUMIFS($Foundry.$J$1:$Foundry.$J$100,$Foundry.$I$1:$Foundry.$I$100,AF4,$Foundry.$B$1:$Foundry.$B$100,"No")
+SUMIFS($Foundry.$L$1:$Foundry.$L$100,$Foundry.$K$1:$Foundry.$K$100,AF4,$Foundry.$B$1:$Foundry.$B$100,"No")
+SUMIFS($Foundry.$N$1:$Foundry.$N$100,$Foundry.$M$1:$Foundry.$M$100,AF4,$Foundry.$B$1:$Foundry.$B$100,"No")
Is that supposed to happen? Is there a way for me to stop that?
And what could the trigger for that be ? I “fixed” it earlier today, saved & quitted, reopened the sheet and it was as I wanted it to be. Now few hours later it reverted back.
