Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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 ajoutée par Islam Al-Hemsi , Chief Accountant , Petra Travel & Tourism Co
Date de publication: 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

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?