Is this possible with an array formula?

[beyond belief]

I have a list of numbers in B2:B20 and I want to create an array of all the combinations of the sums of the list so that I can lookup this array and match a particular number

B2:B3 would be number 1, B2:B4 would be number 2 and so on

Thank you

 

[tactps]

Why not add a column with the formula =sum(B2:B3) in cell C3 and copy down.

Then search on that?

 

[Bruno_x]

Hi beyond belief,
Welcome to the board.

I have a list of numbers in B2:B20 ...
...B2:B3 would be number 1, B2:B4 would be number 2 and so on

Do you only need the sum of B2:B3, B2:B4, B2:B5 etc.
or do you also need the sum of B3:B4, B3:B5,.. B17:B18, B5+B8+B19 ?

In the first case you could use tactps's formula, but make B2 absolute : =SUM($B$2:B3)
The second case is quite another problem (an array with all possible combinations). IMHO, the trick to do this is a technique called 'column generation' A start could be : http://www.mrexcel.com/board2/viewtopic.php?t=59786