Hi,

This can't be done. You can use Solver to find 1 solution, but there may be
a large number of solutions and Solver only returns 1. And this is not a
function, but an Excel Add-in. If you are interested in exploring this topic
area, start by choosing Tools, Add-ins, and check Solver. Then Google Excel
Solver. There are also sample excel files stored in the Samples folder from
Microsoft demonstrating this sophisticated tool.

Why can't it be done? Lets look at a very simple example. You have the
following

1
2
3
4
5
6
7
8
9

And you want to find exactly which numbers total to 10.
1+9
or
2+8
or
3+7
or
4+6
or
5+4+1
....
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"BeachLover" wrote:

I have a list of about 30 numbers in individuals cells in a column that added
up to over 200,000. I need to find the numbers within the 30 numbers that
add up specifically to 109,484.60. What formula can I use?
--
BeachLover