Long Formula in cell and REF!
Dear all,
I have some sheets with raw (source) data. First I copy them from the external XLS or MHTML file. I have button with macro for these actions.
I the next sheets I calculate Initial/Final Balance with static formulas in cells with fields from source or from custom fields.
I lost some of the columns when I replace data with in source sheets ....
Code:
=D2+SUM(SUMIFS(DB_001!$M:$M;DB_001!#REF!;B2;DB_001!$R:$R;">=1";DB_001!$R:$R;"<=3";DB_001!$N:$N;{"ZC02","PAL"}))+SUMIFS(DB_002!$J:$J;DB_002!$B:$B;"ZCG2";DB_002!#REF!;">=1";DB_002!#REF!;"<=3";DB_002!$F:$F;B2)-(--SUM(SUMIFS(DB_002!$J:$J;DB_002!$B:$B;{"ZPAL","ZC02"};DB_002!#REF!;">=1";DB_002!#REF!;"<=3";DB_002!$F:$F;B2))-(-SUMIFS(DB_003!#REF!;DB_003!$E:$E;B2;DB_003!$F:$F;">=1";DB_003!$F:$F;"<=3")-(SUMIFS(DB_001!$M:$M;DB_001!#REF!;B2;DB_001!$R:$R;">=1";DB_001!$R:$R;"<=3";DB_001!$N:$N;"ZCR1"))))
I dont understand why ?!?!
How can I avoid it?
Thank you in advance for help!!
