Getting all the combinations of 2 items from 1 list and adding them together

If I have a list of data in a single column, e.g. A1, A2, A3,....An etc how can I get, and then add up all the possible combinations of those cells with 2 elements. E.g. I want to do A1 + A2, A1 + A3, ... A1+An, A2 + A3, A2 + A4, ... A2 + An, ........................... An-1 + An

At the moment I have a list of 45 items I'd like to do this for and I know there are 990 combinations so it's not something I want to do manually. Also I'd like to be able to extend the method to more than just combinations of 2 later on

Originally Posted by mikeTRON

Can you post a sample workbook?

If you look at sheet 1 in the attached file I have begun the process in column i, working on the entries in column c...

Hi,

Please see attached - is this what you are after ?

Regards

peterrc