View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DJuan DJuan is offline
external usenet poster
 
Posts: 2
Default Formula Help Required

Can anyone tell me if there is a way Excel can do the following?

I need to work out which amounts are added together to make up a total amount.
eg

If I have a list of numbers i.e
1200
1000
2000
3000
1100
900
3120

And I have a total of 4100 is there a formula that can work out how many
combinations (from the list of numbers) can add up to this total?? ie
1. 1200+900+2000
or 3000+1100