Adding a Formula After an Array?
Hi again,
I was wondering if there's a way to have a formula calculate at bottom of an array formula? With the obvious kicker being that the array can vary in length.
I have attached a sample book and expected results, although it doesn't necessarily highlight the issue clearly because the array in question changes regularly which makes adding a formula to the bottom of it very difficult (for me at least)
I am using MS365 Excel v2208 on PC.
Thanks for your time.
Last edited by EricDonk; 04-05-2023 at 12:42 PM.
=LET(s,SEQUENCE(6,1),VSTACK(s,SUM(s)))
or
=VSTACK(SEQUENCE(6,1),SUM(SEQUENCE(6,1)))
Bernie Deitrick
Excel MVP 2000-2010
Wow a quick and perfect solution, thank you very much.
It's quite a simple looking formula so I'm surprised it didn't come up when I googled "another formula after an array" amongst other things. (Must not have been searching the correct terms)
That said I'm taking nothing away from you or the solution because it's invaluable to me. Thank you ever so much.
Thread marked as solved and Rep added. Cheers again Bernie Deitrick. Legend.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks