Calculate Combinations

Hello all,

I am looking for the following solution in Excel spreadsheet and wondering if someone could help: -

I wish to look at a group of numbers and find how many combinations of these numbers added together can reach a certain range.

Example

10 numbers

10,9,11,8,7,4,15,6,18,9

My target sum is between 45 and 55

So combinations could be the following: -

10+11+8+7+6+4=46
10+11+15+18=54
9+8+7+4+6+15=49
10+15+18+4=47

and so on.....

I wish to use a formula to work out how many combinations I can make from a given set of random numbers to achieve a total within a certain range, can anyone make any suggestions for me?

Many Thanks.

Welcome to the board, however, please note your original thread title fell foul of Forum Rules.

Given this is your first post I have on this occasion modified for you. Going please ensure your posts adhere to all of the Boards Rules.