Findknown value by adding selection of a given series of numbers

  • Thread starter Thread starter marty
  • Start date Start date
M

marty

Hi there.

I have a series of numbers and I am given the total that the addition
of some of the numbers in this series needs to equal.

The question is can excel be used to tell me which of the numbers in
the series I am given can be used to give me the total I am after?

For example

Given the following numbers, which numbers will give a total of 26
when added (not any other function) together:
1
10
22
6
13
4
9

Answer to the question is 13 + 4 + 9 or 22 + 4 (but could be others I
havn't notices)

Can anyone help? In real life there may be more possible numbers in
the series.

I tried goal seeker but only has option of one variable - I need more
tahn one variable.

Cheers

Marti.
 
Excel does not have any tool built-in to do this. You could do it with a
macro but then you could use almost any programming language to solve it
also. It's not especially an Excel type of problem.
 
Back
Top