View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chickenshed_bob
 
Posts: n/a
Default searching a range for a sum...


Morrigan - thankyou for the response.

Unfortunatelly, I can't get it to work. In the "solver parameters"
I've set the target cell to equal to an amount which I know exists in
two of the cells in the range (and the two said cells are the only
cells which equal to the amount in the target cell) but it seems unable
to work this out.




--
chickenshed_bob
------------------------------------------------------------------------
chickenshed_bob's Profile: http://www.excelforum.com/member.php...o&userid=32985
View this thread: http://www.excelforum.com/showthread...hreadid=524442