Looking for a little help with another Google Sheet.
I have four columns where, for each row, I have set a pull down value (score) of 0 and 5. In the fifth column (ranking), I calculate a final value as a weighted average score with the following formula: =(sum(G3*G1,H3*H1,I3*I1,J3*J1)/SUM(G1:J1))*20
Where G1 - J1 contain the hidden % weighted values
And columns G3 to J3 (and lower) contain scored ranging from 0 - 5.
The *10 just expands the final value to a number that will allow for easier ranking.
The most important question...
1. Is there a way to copy this formula down the ranking column and only increment values that are shown in bold (G3, H3, I3, J3)? As it stands, it seems that I need to manually enter this formula about 50x. :O
2. I would have used "AVERAGE.WEIGHTED(A1:A2, B1:B2)", but I couldn't figure out how to expand the final value.
Is there a better way to calculate average weighted values and display a larger number than what you would normally see from input values ranging from 0 - 5?