How to normalise estimate weighted on correlations (some will obviously be negative)
The appropriate method, if you have the data to use it, is linear regression.  Simply using correlations fails to take into account that the other variables are also correlated with each other; for example, any averaging method like the one you describe will overweight any duplicated variables.