Forum Discussion
Solved
Dynamic array sumifs 0's till last row won't work
Having this error with a choose method i usually use to fill down text in a zero index dynamic array This example is a project capital budgeting tool that will take some inputs derived f...
I'm also very unclear as to what you require. Do these help?
=VSTACK(SEQUENCE(A1,,0,0),A2)or
=IF(SEQUENCE(A1+1,,A1,-1),0,A2)where A1 and A1 contain 9 and -15500 respectively.
It's not clear what the expected results are supposed to be. If you're not able to attach workbooks, you may provide a link to OneDrive or another file host.