In this article:

How to Make a Grade Calculator in Google Sheets (2025 Guide)

January 13, 2025

How to Make a Grade Calculator in Google Sheets

Follow the steps below to make a grade calculator in Google Sheets.

Step 1: Open Google Sheets and Set Up Your Grade Categories

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%)".

grade calculator google sheets

Step 2: Input Scores

Below each category, input the scores achieved for each. Make sure each score is in the column under its respective category.

how to make a grade calculator in google sheets

Step 3: Calculate Weighted Scores

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

google sheets grade calculator

Adjust the cell reference and weight (0.2 for 20%) as necessary for your data.

grade calculator spreadsheet google sheets

Step 4: Add Weighted Scores

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)

grade calculator in google sheets

Google Sheets Grade Calculator

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.

We hope that this article has helped you and given you a better understanding of how to make a grade calculator in Google Sheets. If you enjoyed this article, you might also like our articles on how to use SPARKLINE in Google Sheets to make a progress bar and how to use Autocrat with Google Sheets.

Turn PDFs into spreadsheet tables with AI

Use Lido to extract data from contracts, invoices, financials, and more in seconds. Save time, reduce errors.
  • No credit card required
  • 20 free pages