SOLVED

# Does the column function spill?

Regular Contributor

# Does the column function spill?

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

8 Replies

# RE: Does the column function spill?

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

# RE: Does the column function spill?

Here is an excample file.

I would like to sum each column at the top.

/Geir

best response confirmed by Geir Hogstad (Regular Contributor)
Solution

# RE: Does the column function spill?

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

# RE: Does the column function spill?

Thank you Detlef, this was brilliant.

/Geir

# RE: Does the column function spill?

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.

# RE: Does the column function spill?

This point I am not sure.

# RE: Does the column function spill?

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

# RE: Does the column function spill?

IFS() is not available for 2016

IFS function - Office Support (microsoft.com)