How would I create a spillable function that computes across rows of mutliple spillable functions?
For example:
Let's say I have a simple sequence in Column A, I have three spillable arrays in B, C, D (this is not a matrix, but these are instead three unique spillable columns). Each spilling range has an equal number of rows always.
Now let's say I want to create a product or a sum or some other function across each row. For example Sum (B5:D5) in Cell E5 and so on down each row in the column ... BUT, I want this to be spillable!
Screenshot 2022-09-26 164126.png
This seems like it should be easy to do - but I am having challenges and I have tried, offset, returning a row through INDEX. I can't figure out a way to make it spillable though.
Bookmarks