View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student
 
Posts: n/a
Default calculate values

Do you need exactly 8 numbers. Suppose we can reach 360 by only adding two
or three?
--
Gary's Student


"galbertse" wrote:


I have a column with 25 values in it. I would like excel to SUM eight of
these cells to a total value of 360 or less. The eights cells needs to
be identified and the total must be as close a possible to 360. Is this
function possible in excel?


--
galbertse
------------------------------------------------------------------------
galbertse's Profile: http://www.excelforum.com/member.php...o&userid=32383
View this thread: http://www.excelforum.com/showthread...hreadid=521472