Originally Posted by Lneal
=$B17*$C8+$C9*$C17+$C10*$D17+$C11*$E17
This is the formula that I entered using absolute cell reference. Have I entered it wrong? Thanks for your help.
The values that have the weights should have two $. So say that the one value (b17, c17, d17, e17) is the student's grade and the other value (c8, c9, c10, and c11) is the weight, the weight will be the same for each student. It should be:
=$C$8*$B17+$C$9*$C17+$C$10*$D17+$C$11*$E17
(BTW - I reversed the values in the first two so that they are consistent).