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(B5:D5,$B$2:$D$2)/SUMPRODUCT(--((B5:D5)0),$B$2:$D$2)

Tom