I don't know if it makes a difference but I am working with excell office 2003
--
Thanks, Kate


"Peo Sjoblom" wrote:

Here's a method using the solver add-in, otherwise you would need VBA


http://tinyurl.com/yqnogr


mind you that the solver that comes with excel is limited to how much number
crunching it can do


--


Regards,


Peo Sjoblom


"Kate" wrote in message
...
I have a column with totals in it (numbers). From this array of numbers I
want to search for any combination by (adding these numbers together) that
will equal a number in another cell say B3.

Another way to say this is: in Column A I have in each row a number. In
cell B3 I have the number I am looking for, which could be any combination
of
adding the numbers from Column A. Is their a way I can search column A
and
come up with a combination that will equal what I am searching for in Cell
B3?

Column A Column B
1
2
3 26
4
5
6
7
8
9
...

--
Thanks, Kate