View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joshua Jacoby
 
Posts: n/a
Default find values that add up to certain amount

I have a long list of monetary amounts listed on an excel spreadsheet. I am
trying to find combinations of those amounts that add up to certain larger
sums. For example on a smaller scale:
10
15
21
41
53
How can I find the cells that add up to 108? Is there a formula or function
I can use on a large scale for this type of thing?