How create a database with the sums of all possible combinations of 2 to 8 elements from 28 different numbers?

I have 2 columns with 28 different numbers each, I need to create a database using excel program with the sums of all possible combinations between 2 and 8 elements from 28 numbers in each column and compare the results to find identical results.


For example in the first column the sum of 3550+50+500+125+18.40=4234.40 its identical with the sum of 2000+2220+14.4=4234.4 in the second column. In other words I need to find identical sums with different number of elements between both columns.


I don麓't know how create a program in excel that let generate automatically all possible sum of combinations from 2 to 8 elements from 28 quantities in both columns and then compare one with other in order to find identical results.


Can someone help me?


Thank you.How create a database with the sums of all possible combinations of 2 to 8 elements from 28 different numbers?
use loops and if then statements. The code in VB should about 15-20 lines