What is the Excel formula for GWA?

Use =SUMPRODUCT(B2:B10,C2:C10)/SUM(C2:C10) when grades are in column B and units are in column C. Expand the ranges to match your subject rows.

Can I use the same GWA formula in Google Sheets?

Yes. Google Sheets supports SUMPRODUCT and SUM, so the same weighted-average formula works when your grade and unit ranges are correct.

Should PE, NSTP, or non-credit subjects be included?

Only include subjects that your school counts in GWA. If a course is excluded, leave it out of the grade and units ranges or put it in a separate reference section.

GWA Calculator Excel Template and Formula

Build a reusable GWA calculator in Microsoft Excel or Google Sheets with the correct weighted-average formula.

Use this page when you want a spreadsheet you can save, edit, or share instead of calculating grades only in an online form.

Core formula: multiply every grade by its units, add the products, then divide by total units.

Formula Builder

Copy this Excel / Sheets formula

=SUMPRODUCT(B2:B10,C2:C10)/SUM(C2:C10)

Sample GWA from table below

1.67

Total units

Use Online Calculator

Starter GWA Spreadsheet Layout

Use this layout in Excel, Google Sheets, LibreOffice Calc, or Numbers. Keep grades as numbers, keep units as numbers, and avoid mixing excluded subjects inside the same formula range.

Column A: Subject	Column B: Grade	Column C: Units	Grade x Units
Mathematics	1.50	3	4.50
Science	1.75	4	7.00
English	1.25	3	3.75
History	2.00	3	6.00
Major Subject	1.50	5	7.50

Where to place the final formula

Put the formula in any empty cell, such as E2. If your subjects run from row 2 to row 6, use =SUMPRODUCT(B2:B6,C2:C6)/SUM(C2:C6). If you add more rows, extend both ranges to the same last row.

Excel Template vs Online GWA Calculator

Both options use the same weighted-average idea, but they solve different student workflows. Choose the spreadsheet when you want a saved record, and choose the online calculator when you only need a fast result.

Need	Use Excel or Google Sheets	Use the online calculator
Save semester records	Best choice because you can keep one workbook per term or school year.	Useful for a quick check, but results are not stored after you leave the page.
Try many grade scenarios	Best for copying rows, adding notes, and comparing possible final grades side by side.	Best for simple what-if checks with a few subjects.
Avoid formula mistakes	Requires careful range checks when you add or remove subjects.	Safer if you do not want to manage spreadsheet ranges manually.
Share with classmates or advisers	Best when you need an editable file or a Google Sheets link.	Best when you only need to show the calculation method.

How to Make a GWA Calculator in Excel

1. Set up columns

Create columns for subject, grade, and units. Keep grade values like 1.25, 1.50, 2.00, or 3.00 in numeric format.

2. Enter counted subjects

Include only the subjects your school counts in GWA. Put excluded PE, NSTP, audit, or non-credit courses outside the formula range.

3. Add SUMPRODUCT

Use SUMPRODUCT to multiply each grade by units, then divide by the SUM of units. This is the weighted average formula.

4. Check the result

A lower GWA is usually better on the Philippine 1.00 to 5.00 scale. Compare the result with your official school policy before submitting it.

Excel Formula Examples for Common Layouts

Spreadsheet layout	Formula	Best use case
Grades in B2:B10, units in C2:C10	`=SUMPRODUCT(B2:B10,C2:C10)/SUM(C2:C10)`	Standard GWA calculator Excel sheet.
Grades in C2:C20, units in D2:D20	`=SUMPRODUCT(C2:C20,D2:D20)/SUM(D2:D20)`	Sheets where column B is used for section or professor notes.
Semester GWA in B2:B5, semester units in C2:C5	`=SUMPRODUCT(B2:B5,C2:C5)/SUM(C2:C5)`	Cumulative GWA across multiple terms.
Named ranges GradeRange and UnitRange	`=SUMPRODUCT(GradeRange,UnitRange)/SUM(UnitRange)`	Reusable templates with cleaner formulas.

Troubleshooting Your GWA Calculator Spreadsheet

The formula returns #DIV/0!

This usually means the units range is empty or totals to zero. Check that all counted subjects have valid numeric units and that the formula range points to the correct column.

The result looks too high or too low

Make sure the grade scale is consistent. Do not mix 1.00 to 5.00 GWA values with 0 to 100 percentage grades in the same formula unless you convert them first.

Excel ignores some rows

Confirm that your formula range includes every subject row. If you added rows below row 10 but your formula still ends at B10 and C10, the new subjects are not included.

Excluded courses change the GWA

Put excluded courses outside the SUMPRODUCT range or keep a separate "Included?" column and filter your official copy. For University of the Philippines planning, the UP GWA Calculator also has exclusion controls.

Related Tools and References

Need a quick result without a spreadsheet? Use the GWA Calculator Philippines.
Already have semester averages? Use the Cumulative GWA Calculator.
Need to interpret a result like 1.46 or 1.75? Use the GWA Equivalent Calculator.
Microsoft documents SUMPRODUCT and SUM, the two spreadsheet functions used in the formula.
Google documents SUMPRODUCT in Google Sheets for users who prefer a cloud spreadsheet.

GWA Calculator Excel FAQ

Use =SUMPRODUCT(B2:B10,C2:C10)/SUM(C2:C10) when grades are in column B and units are in column C. Change the row numbers if your subject list is longer or shorter.

Yes. The same SUMPRODUCT formula works in Google Sheets. You can also download the CSV starter template from this page and import it into Google Sheets.

Yes. Put each semester GWA in one column and semester units in another column, then use the same weighted-average formula. For an online version, use our cumulative GWA calculator.

For planning, two decimal places is usually readable. For official use, follow the number of decimal places and rounding policy required by your school or registrar.

No. This is a planning template that follows the weighted-average formula. Use your official transcript, student portal, registrar rules, and school handbook for final academic decisions.

Want an instant result first?

Use the online calculator to check your GWA, then copy the formula above into Excel when you want a reusable spreadsheet.

Open GWA Calculator