Array Formula Dragging Problem

[Oprichnick]

Hello,
I'm having some trouble with dragging an array formula.

Before... When I dragged the array formula, in the new cells the formula was correct and there was no need to do Ctrl+shift+enter again in each new cell.

Suddenly, out of nowhere, today I opened the file ... and it is now needed to do ctrl+shift+enter in each new cell to get the right result. Strangely in each new cell the formula is correct (and has the array brackets).

I have looked everywhere...

Thank you for your help in advance,
Pedro

 

[DRSteele]

I can't imagine. Please post some sample data; you can do so by following the links in my signature below.

 

[Oprichnick]

F(x) = {Average(IF(ISERR(C4:AM4);"";IF(ISBLANK(C4:AM4);"";C4:AM4)))}

When I drag down the formula, it is being pasted correctly. That is (C5:AM5) - (C6:AM6) etc. ... however, now I have to put a matrix bracket in every new cell to get the true result.

Now if the cell I drag down has, for example, 15 as result... all new cells will have 15 also. I need to do ctrl+shift+enter in each cell to get the correct.

Before it didnt happened.

 

[konew1]

Do you have automatic recalc disabled?

 

[Oprichnick]

Oh god :S

Of course. Thank you very much.

 

[konew1]

Oh god :S

Of course. Thank you very much.

We have all done it sometime