Thread: Find numbers in an array that sum to a certain number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tommydancer tommydancer is offline
external usenet poster
  
Posts: 1
Default Find numbers in an array that sum to a certain number
How do I get Excel to search an array of numbers and find only those numbers
that sum to a certain total? Which of the following numbers (3,5,7,14,20)
total 22? Answer: 3, 5, and 14 total 22
Reply With QuoteReply With Quote