Hi Tom, thanks so much!! That was so helpful!!
Can you tell me how it calculating the weights? How are the weights
redistributed if it isn't 50-50?
"TomPl" wrote:
Though it does the same thing, I like this formula a little better:
=SUMPRODUCT(B55,$B$2:$D$2)/SUMPRODUCT(--((B55)0),$B$2:$D$2)
Tom