Combine - by summing - two arrays into a third

Hi,

I know a few ways to accomplish the task but I'm curious to know if there is a syntax which will "Do it My Way".
The following code will fill Arr1 cells with 10 values from range A1:A10 and then fill F1:F10 with those values.

Please Login or Register  to view this content.

Now, assume 2 ranges (A1:A10 and B1:B10)
Putting each range into an Array is easy - as shown in the 2 first commands of the following code.

I want to add cell 1 of Arr1 with cell 1 of Arr2 and put the result in cell 1 of Arr3
I have tried:

Please Login or Register  to view this content.

Is there a way to fill Arr3 with Arr1 & Arr2 cells sum with a single command (WITHOUT LOOPING) ?.

'Join' and 'Split' don't seem to do any good.

Thanks, Elm

Originally Posted by ElmerS

Is there a way to fill Arr3 with Arr1 & Arr2 cells sum with a single command (WITHOUT LOOPING) ?.

Not that I'm aware of.

Though this will invariably fall foul of your specific requirements I would (for the benefit of others) suggest using Evaluate...

Please Login or Register  to view this content.

or if you want to store as an Array

Please Login or Register  to view this content.