I have this array formula:
When the values for $N32 and $N$7 change, the formula does not re-calculate automatically as expected.
If I press [F2]-Edit and then [Ctrl][Shift][Enter] to re-enter the array formula, it re-calculates correctly.
If I copy the formula into a cell, it it re-calculates correctly.
Is it just one of those Excel quirks or is it me???
I have checked that calc mode is set to automatic.
I have checked that the specific sheet has EnableCalculation set to True.