SOLVED

Does the column function spill?

Steel Contributor

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)))

 

column spill.PNG

 

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

8 Replies
I cannot see IFS in my excel 2016. Could you advise what the problem?

@LY_Sokphou 

 

Here is an excample file. 

 

I would like to sum each column at the top.

 

/Geir

best response confirmed by Geir Hogstad (Steel Contributor)
Solution

@Geir Hogstad 

=MMULT(SEQUENZ(,ROWS(H8#))^0,H8#)

 

Thank you Detlef, this was brilliant.

/Geir
Hi Geri, I mean function “IFS” no found in my Microsoft excel 2016. Can you help to add it for me? I try to find most many way. But still no idea how to set it up for using.

Pls see my screenshot.
This point I am not sure.
I am sory. But this is beyong my skills. I Guess you should contact Microsoft support to get some help on this. Or google to see which version IFS is in.

/Geir
1 best response

Accepted Solutions
best response confirmed by Geir Hogstad (Steel Contributor)
Solution

@Geir Hogstad 

=MMULT(SEQUENZ(,ROWS(H8#))^0,H8#)

 

View solution in original post