Grades with different percentages
Solved
colinep11
Posted messages
9
Status
Member
-
colinep11 Posted messages 9 Status Member -
colinep11 Posted messages 9 Status Member -
Hello,
I created a table where I display my university grades to calculate my average. However, some grades are worth more than others.
For example, in American Civilization, the first test was worth 30% of the final grade and the second test is worth 70%.
In the first test, I got 8.5/20 and in the second, I got 17/20.
What formula should I apply to get the average of these two grades based on the different percentages assigned to them?
Thank you for your help!
Configuration: Windows / Firefox 43.0
I created a table where I display my university grades to calculate my average. However, some grades are worth more than others.
For example, in American Civilization, the first test was worth 30% of the final grade and the second test is worth 70%.
In the first test, I got 8.5/20 and in the second, I got 17/20.
What formula should I apply to get the average of these two grades based on the different percentages assigned to them?
Thank you for your help!
Configuration: Windows / Firefox 43.0
1 answer
-
Good evening colinep,
Assuming the grades are in the range B2:C2 and the weights (either as percentages or simply 3 and 7) in B3:C3, in the cell where you want the average you put the formula:
=SUMPRODUCT((B2:C2)*(B3:C3))/SUM(B3:C3)
Best regards
Via
--
"Imagination is more important than knowledge." A. Einstein
