Nasp

2011-10-22, 01:39 AM

http://www.mrexcel.com/forum/images/buttons/reportpost.gif (http://www.mrexcel.com/forum/report.php?p=2905259)

http://www.mrexcel.com/forum/images/icons/icon1.gif Help with sum formula

Hello,

I am new to excel and and it would be amazing if anyone could help me out.

I have around 2000 rows with a set of 8 different numbers in each row. For instance,

2-4-7-11-15-29-35-36

4-16-20-29-32-37-49-50

etc...

Is it possible to be able to get if any 2 numbers in each line add up to a 3rd number?

For instance, in

1) 4-7-11-12-40-42-56-83, 4 + 7 add up to 11.

So I would like to get the sum 11.

2) If there are more two pairs of numbers that add up to a third number, for instance, in 1-2-4-16-20-29-49-210, 4 + 16 add up to 20 and 20+29 add up to 49, I would like to get again as a result the two sums.

If the above is not possible, please suggest any other way that I can get an indication that the lines have the above characteristic. For instance instead of getting the sums, get the number 1 instead of 11 as in the first example and get the number 2 when two pairs add up to a sum as in the second example.

I hope someone can help me out.

Thank you

Nasp

http://www.mrexcel.com/forum/images/icons/icon1.gif Help with sum formula

Hello,

I am new to excel and and it would be amazing if anyone could help me out.

I have around 2000 rows with a set of 8 different numbers in each row. For instance,

2-4-7-11-15-29-35-36

4-16-20-29-32-37-49-50

etc...

Is it possible to be able to get if any 2 numbers in each line add up to a 3rd number?

For instance, in

1) 4-7-11-12-40-42-56-83, 4 + 7 add up to 11.

So I would like to get the sum 11.

2) If there are more two pairs of numbers that add up to a third number, for instance, in 1-2-4-16-20-29-49-210, 4 + 16 add up to 20 and 20+29 add up to 49, I would like to get again as a result the two sums.

If the above is not possible, please suggest any other way that I can get an indication that the lines have the above characteristic. For instance instead of getting the sums, get the number 1 instead of 11 as in the first example and get the number 2 when two pairs add up to a sum as in the second example.

I hope someone can help me out.

Thank you

Nasp