Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

If I have 10 numbers what is the proper way to get a summation of some of them or all of them to get a specific number using EXCEL?

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

user-image
Question added by Islam Al-Hemsi , Chief Accountant , Petra Travel & Tourism Co
Date Posted: 2016/11/23

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

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.