I have a complex spreadsheet that makes use of lots of Array formulas.
I have protected cells and sheets as much as possible.
However, inexplicably, on rare occasions, after unknown user actions, a few of the array formula occasionally display the syntax of the array formula and not the result of the formula. This causes an error in the total calculation as the cell is treated as a zero value instead of what the formula would have calculated. I can’t think of what it is that the user has done that might cause this to happen. The Array formula concerned is:
Error in cell B83.
The same formula is copied down from B83 to B100.
I’m guessing that the user is cutting and pasting or doing something like that in one of the input fields in the source sheets. But I can’t see any pattern. Sometimes it happens when the value generated would have been zero/blank in any case. Other times there should have been a value generated. Has anyone got any ideas why the formula would display like this?
Here is the Google Drive link for the file:
The password to unprotect sheets is blank.