Good Morning,

Is there a formula or function in excel that would allow me to model a set a variable inputs to calculate a set output?

For example

10 5 1 12 49 44
20 10 2 24 1 63
30 15 3 36 17 10
40 20 4 48 41 83
50 25 5 60 14 46
60 30 6 72 30 3


Say the set out put is 500 for the sum of Column 1,2,3,4,5,6 but i need to correct set of number in each column to get the set output.

Thoughts?

Thanks