• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic addition.

Ufoo

Member
Hello excel gurus, please see the attached sheet and help. Thanks
 

Attachments

  • Dynamic addition.xls
    17.5 KB · Views: 15
in the cells(B4) Try this formula
=IF(B2<>"",0,SUM(A$4,1))
and fill to right
 

Attachments

  • Dynamic addition_new.xls
    24 KB · Views: 2
Hi, to all!

Another similar approach, without volatile functions:

[C2] : =IF(C4,"",LOOKUP(9E+307,$B2:B2)+INDEX($B4:$M4,COUNT($B2:B2))) <-- Drag it right.
or (positive numbers):
[C2] : =IF(C4,"",-LOOKUP(,-$B2:B2)+INDEX($B4:$M4,COUNT($B2:B2))) <-- Drag it right.

Blessings!
 
This is a dynamic array solution. Let k be defined to refer to
= SEQUENCE(1, 21, 0)
i.e. integers from 1 to 20. The required number sequence is given by
= IF( MOD( k, 4 ), "", 5 + (1 + k/4) * k/8 )

Because dynamic arrays do not evaluate accumulations, I summed the series analytically and entered the resulting formula.
 

Attachments

  • Dynamic addition (PB).xlsx
    17.4 KB · Views: 3
Back
Top