Sorry, I might be missing something here but, if you just want a simple array function that you want to drag down, I think you'd just put:
committed with Ctrl-Shift-Enter rather than just Enter.
If you want to get the sum of the arrays, then you'd use:
committed with Ctrl-Shift-Enter rather than just Enter
or, alternatively:
. Note: this is not an Array Formula
Like I say, I might be missing something in my understanding or your requirement.
If the formula is more complex, perhaps you can share it with us.
Regards, TMS
Bookmarks