Register now or log in to join your professional community.
Example: If I have the following8,4,2,7,9 ,5,1,9,6,3 what are the ways to get TWENTY from the sum of all numbers or some of them
Are you wanting EXCEL to figure out what number in the sample would equal a specific number? I'm not sure if that is possible or not Islam. I've used EXCEL extensively over the years but have never tried to get it to do that. I did a web search and found this link that may answer your question though.
http://superuser.com/questions/204925/excel-find-a-subset-of-numbers-that-add-to-a-given-total
