Add all numbers in a range to every other number in the range

[Metserv]

Greetings.

I have a range of values in column A, I wish to add all numbers by all other numbers, i.e for a specific value in the range, I want to add it to all the other values in the range, and output the values in a new range.

For example for values 1,2,3,4 in range A2:A5, I want to output a new range the values;

1+2 =3
1+3 =4
1+4 =5
2+1 =3
2+3 =5
2+4 =6

e.t.c, beginning in range B2. No number can be added to itself.

Thank you in anticipation.

 

[Metserv]

THANKS. It works perfectly for the two sets. For the sets of three, the combinations work, though the last combinations for the last item are not generated, i.e for 1,2,3,4, it generates 1 1,2 1,3 1,2,3 2 2,1 ........ BUT it does not generate 1,3,2 which should come AFTER 1,2,3. This item is part of the combinations beginning with 1. I understand I may have been vague with my expected output range. I also understand it may be rather complicated to generate ALL possible sets of combinations for even a LARGER range. Thank you for you assistance thus far, I will try explaining its difficulty to the user or seeking further help if it cant be figured out for now. Thank you.