I already asked something similar.
It was just to now how to calculate a weigthed average in Excel
So now I have this in some cells :
The "weights" are in column A2...An
The "scores" are in column C2...Cn for person C, D2..Dn for person D etc...
The weighted averages are in A1..X1 using this formula (thanks to EE !), for example for person C
But now I come with something more complex to calculate !
There are now two "weights column, says A and B
All scores are always positive but I put a score positive, if its weight is in column A and as negative (a tric) if in fact it is of course positive, but the weight is in column B !
How now to calculate the weigthed averages
A B C
2 3 50
1 4 -40
The weigthed average for column C is ((2 * 50) + (4 * 40)) / (2 + 4)