Follow the steps below to make a grade calculator in Google Sheets.
Open Google Sheets and create a new spreadsheet. Label the first row with the different grade categories and their weights. For example, "Homework (20%)", "Quizzes (30%)", "Midterm (25%)", "Final (25%)".
Below each category, input the scores achieved for each. Make sure each score is in the column under its respective category.
To calculate the weighted score for each category, you’ll use a formula. Assuming "Homework" scores start in B2, you can calculate the weighted score for Homework in a new cell with:
=B2*0.2
Adjust the cell reference and weight (0.2 for 20%) as necessary for your data.
After calculating the weighted score for each category, find an empty cell where you want to display the final grade. Use the SUM function to add up all the weighted scores. If your weighted scores are in cells C2, C3, C4, and C5, the formula will look like:
=SUM(C2:C5)
Here is a sample grade calculator you can copy and edit for yourself. Make sure to adjust the ranges and percentages according to your setup.
You can add more rows for each category if you have multiple scores per category and then sum those before multiplying by the category weight.
How to Make Funnel Charts in Google Sheets
Find and Replace Blank Cells in Google Sheets (2025 Update)