Hi John

Thanks for your post.
I couldn't get the correct result.
Could you please place an example.

--
sarans


"John Michl" wrote:

You could try using solver. I haven't done this in many years so I
don't remember the specifics. I think I set up a column adjacent to my
list of numbers. In the second column, I entered the number 1. I then
used =SumProduct(ColA:ColB) which equalled the sum of all numbers
(since they were multiplied by one.) I then used Solver to "play" with
the column of 1's setting some of them to zero until the formula
equalled the target value.

- John