SheetsdrillWeighted average score
A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Each course component has a score and a weight. Work out the weighted average score in E1: the sum of every score times its weight, divided by the sum of the weights. Use SUMPRODUCT.
What this exercise teaches
AVERAGE would treat every component as equal. Dividing by the sum of the weights means the formula still works when the weights do not add up to 100.
A hint if you get stuck
SUMPRODUCT(B2:B5, C2:C5) multiplies the two columns row by row and adds the products. Divide that by SUM of the weights.
Try it now, free, no account needed
The first 15 tasks on Sheetsdrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro adds timed mode and the certificate.
Open this exerciseMore exercises in Conditional counting and summing
- Open high-priority ticketsPro
- Sales for one rep and monthPro
- Won deals above a minimumPro
- Average reply timePro
- Largest order in a regionPro
- Cheapest item in stockPro
- Orders between two datesPro
- Customer tiers with IFSPro
- Region names with SWITCHPro
- Contacts on one email domainPro
- Active SKUs with a prefixPro
- Free shipping rulePro
- Rank without RANKPro