Sep 30 2022 07:53 AM
hi what a formula may I use to extract from a set of number the 10 (or more or less) that returs a given sum? thanks
Oct 01 2022 12:53 AM - edited Oct 01 2022 02:05 AM
Welcome to your Excel discussion space!
Use the SUM function to sum numbers in a range
You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM(A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.
Hope I was able to help you with this information.
I know I don't know anything (Socrates)
Oct 01 2022 03:01 AM
thanks@NikolinoDE for your kind reply. my question was not correct or clear enought. i've found a way using the "excel added function(?)" RISOLUTORE in italian maybe SOLVER (matrix. product.sum) in english.
now I've to find a way how to set the as added restriction to the bin column: the sum has to be 10 (that is: among the given set of 40 numbers the solver has to give me the 10 numbers that give me the target number I've put in) this should reduce the possible solutions to the most likely.