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

    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.

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


    Cross posted: http://www.mrexcel.com/forum/e…y-other-number-range.html


    Please note that the rules, both here and on MrExcel require you to include links to all your posts dealing with a particular issue on other boards. To understand why, please have a read of this link.


    You should update this thread with a link to any other posts and as a courtesy to others, update your other post(s) as well.


    To include a link in a message, copy the URL from the address bar of your browser, edit your message and paste...

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login