Returning a value in a range
 

I want to take a sum (see example, 44) and have it look at the first row of
numbers , choose numbers that equal the total of 44 and return the value
(number) in the second row.
44

32 24 16 12 8 4
2 1 1
Any suggestions?
THANKS

Returning a value in a range
 

To select items that combine to form a fixed sum, use Solver:

http://www.tushar-mehta.com/excel/te...ues/index.html

--
Gary''s Student - gsnu200751


"Gigi" wrote:

I want to take a sum (see example, 44) and have it look at the first row of
numbers , choose numbers that equal the total of 44 and return the value
(number) in the second row.
44

32 24 16 12 8 4
2 1 1
Any suggestions?
THANKS