View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JOSEPH WEBER JOSEPH WEBER is offline
external usenet poster
 
Posts: 33
Default TOTAL OF A RANGE SHOULD BE

Is there a function or formula that can calculate which numbers add up to
another. for example:

5
6
7
8

I want the combination of numbers that will give me 21. In other words I
know what the answer should be, just need to find out which combination of
numbers will give me the answer.