You can use Solver or VBA


See:

http://www.tushar-mehta.com/excel/te...ues/index.html
--
Gary''s Student - gsnu200751


"Linda" wrote:

Is there a function in Excel where you can select a column of figures, then
ask what figures in the column add up to a certain amount? Example - you
have a check for $24,674.82 and a long list of amounts. The check may be for
20 or 30 amounts totaled together in the column. Thanks!