Key points in 10 seconds
Three steps
Convert grades to a scale of 20, average assessments within each subject, then combine subject averages using subject weights.
Use total weight
For a weighted average, divide the weighted sum by the sum of all weights.
Check for free
Enter your grades on Outilo and find the score needed on your next assessment.
An overall grade average out of 20 has two levels: assessment grades within each subject and subject averages within the overall result. Weights may apply at either level. You can enter your own grades in Outilo's free grade-average calculator.
Formula: overall grade average out of 20
When all subjects have equal weight, add their averages (each out of 20) and divide by the number of subjects.
Simple overall average = sum of subject averages ÷ number of subjects.
For example, maths 12/20, French 15/20 and history 14/20 give (12 + 15 + 14) ÷ 3 = 13.67/20.
If subjects have different weights:
Overall average = sum (subject average × subject weight) ÷ sum of subject weights.
A subject with more assessments does not automatically have a higher subject weight.
Step 1: convert grades to the same scale
Before combining grades, convert them to a scale of 20:
Grade out of 20 = earned points × 20 ÷ maximum possible points.
| Original grade | Converted grade |
|---|---|
| 7/10 | 14/20 |
| 12/15 | 16/20 |
| 18/20 | 18/20 |
You cannot average 7/10 and 18/20 as if both numbers were already out of 20.
Step 2: find each subject average
Each assessment may have its own weight. Consider these grades in one subject:
| Assessment | Grade out of 20 | Weight |
|---|---|---|
| Test | 12.5 | 1 |
| Exam | 15 | 2 |
| Quiz, originally 7/10 | 14 | 2 |
Weighted average: (12.5 × 1 + 15 × 2 + 14 × 2) ÷ (1 + 2 + 2) = 70.5 ÷ 5 = 14.10/20.
If no weights are specified, use a weight of 1 for each assessment, subject to your school's rules.
Step 3: combine subject averages
Now use subject weights, which are not the same as assessment weights.
| Subject | Average out of 20 | Subject weight |
|---|---|---|
| Maths | 14.10 | 3 |
| French | 13 | 2 |
| History | 16 | 1 |
Overall average: (14.10 × 3 + 13 × 2 + 16 × 1) ÷ 6 = 14.05/20.
With equal subject weights, use the simple average of the subject averages. Check how subjects with no assessed grades are handled rather than assuming they count as zero.
What grade do you need on the next assessment?
Assume your current weighted total is 70.5 from assessments with a combined weight of 5. You want a subject average of 15/20, and the next assessment has weight 2.
(70.5 + 2 × N) ÷ 7 = 15.
Solving gives N = (15 × 7 − 70.5) ÷ 2 = 17.25/20. If the answer exceeds 20/20, the target cannot be reached with this single assessment under these assumptions.
Outilo's calculator can find the grade you need automatically.
Calculate a grade average in Excel
For grades that are already all out of 20 in cells A2:A4, use:
=AVERAGE(A2:A4)
With grades in A2:A4 and their weights in B2:B4, use:
=SUMPRODUCT(A2:A4,B2:B4)/SUM(B2:B4)
For 12 with weight 1, 15 with weight 2, and 14 with weight 3, the result is 14/20. Keep both ranges the same size and ensure total weight is greater than zero. On French-language Excel installations the functions are MOYENNE, SOMMEPROD and SOMME, with semicolon separators.
See Microsoft's Excel average documentation.
A quicker option: Outilo
The free grade-average calculator includes a quick mode and a subject-by-subject mode. It supports different grade scales, assessment weights, subject weights, and targets for the next assessment. Your gradebook is stored locally in your browser and can be exported as JSON; no account is required.
Common mistakes
- Dividing by the number of grades instead of the sum of weights.
- Mixing grades with different maximum scores without converting them.
- Confusing the weight of an assessment with the weight of a subject.
- Rounding each intermediate average too early.
- Automatically counting missing or unassessed grades as zero.
Schools and universities can have different rounding, compensation and pass/fail rules, so this is a mathematical estimate rather than an official transcript result.
Key takeaway
Convert grades to a common scale, compute each subject's weighted average, then combine those averages using subject weights. Check your result with Outilo's grade-average calculator.
Related: how to calculate a weighted average.
More questions answered
Calculate my average
Calculate your overall average out of 20 with weights. Keep your grades by subject and find the grade needed on your next assessment.
Quick answers related to this topic
Sources & methodology
- Microsoft Support – Calculate an average: simple and weighted averages using SUMPRODUCT and SUM; accessed 19 November 2026.
- Microsoft Support – AVERAGE function: AVERAGE syntax, blank cells and zeros; accessed 19 November 2026.
- Microsoft Support – SUMPRODUCT function: summing products of corresponding ranges; accessed 19 November 2026.
- Outilo – Grade average calculator: calculation modes, weights, grade targets and local storage as documented by the tool; accessed 19 November 2026.
- Outilo editorial method: worked examples involving grades out of 20, scale conversion, subject weights and target grades were calculated for this guide. Official grading, rounding and compensation rules vary by institution and are not established by Microsoft's documentation.
This content follows Outilo's editorial guidelines.
Was this guide helpful?
You can change your vote at any time. Click again to cancel.