Aug 10 2021 05:39 AM
Hi,
The goal here is to make a dynamic formual at the top of each column, that spill automatically based og number of columns.
English translation:
=IF(C6#<>"";SUM(OFFSET($B$6;2;COLUMN()-2;ROWS($C$8#);1)))
It does not change the value of Columd when it spills.
If i copy the Offset formula it does pick the right column.
=Offset($B$6;2;Column()-2;ROWS($C$8#);1)
Best Reagdrs
Aug 10 2021 05:45 AM
Aug 10 2021 06:17 AM
Aug 10 2021 07:26 AM
SolutionAug 10 2021 07:51 AM
Aug 10 2021 10:56 AM
Aug 10 2021 11:38 AM
Aug 10 2021 12:45 PM
Aug 10 2021 07:26 AM
Solution