A request for help for Merge & Center cells without effecting a formula

[yanivp1]

Hello everyone.


I would like to Merge & Center cell B7 with cells B6 + B5 + B4, but i don't want that the copied data from the upper table to the lower table will be damaged.


What should I change at the formula?


Thanks a lot!

https://mhtramla-my.sharepoint.com/...hKN9LOf_Q4&e=67885ad2d1fe49878275a20a1fa1aa55

 

[yanivp1]

What should I change at the formula of cell F55?*

 

[FDibbins]

We always advise to avoid using merged cells if at all possible, they cause all sorts of problems with formulas and stuff.

Keep in mind that when you DO have to merge cells, only the top left cell gets used (for data or formulas), anything in ANY of the other cells gets deleted - thats just the way it works

 

[yanivp1]

Thanks a lot for your answer!

Have a nice week,
Yaniv.