Others

How to Create Weighted Questions and Averages in Microsoft Forms

Khadija Khan Oct 12, 2026 868 views

Question details

Determine if Microsoft Forms has built-in support for assigning weights to questions and find methods to calculate weighted averages for survey responses.

How to Calculate Weighted Questions and Averages in Microsoft Forms

Product: Microsoft Forms
Device & OS: not provided
Scenario: Creating a customized survey or quiz where certain questions carry more weight or importance than others.
Observed behavior: Microsoft Forms lacks a native feature for assigning weights to questions, requiring users to export data or use automated flows for calculations.

Before you start

Ensure you have access to Microsoft Power Automate and basic knowledge of creating flows, as the primary workaround involves automating response calculations.

Solution 1Recommended

Use Power Automate to Calculate Weighted Scores

Since Microsoft Forms lacks native weighting, you can use Power Automate to extract responses, apply mathematical calculations, and save the weighted results.

Power Automate allows you to capture form submissions in real-time and apply custom logic to calculate averages before sending the data to an Excel file or database.

Create your Microsoft Form

Design your survey or quiz in Microsoft Forms with all the necessary questions and choice options.

Set up a Power Automate flow

Go to Power Automate, create a new automated cloud flow, and select the trigger 'When a new response is submitted' for your specific form.

Retrieve form responses

Add the 'Get response details' action to your flow to pull the specific answers provided by the respondent.

Apply weighted calculations

Use the 'Compose' action or initialize variables to assign specific numerical weights to the answers, multiplying the response values by your desired weights.

Save the calculated results

Add a final action to write the calculated scores and averages into a file, SharePoint list, or database.

Use Power Automate to Calculate Weighted Scores

Community Support: For help building a specific calculation flow, post your requirements in the official Microsoft Power Automate Community forums.

Free Microsoft Office alternative

Calculate Survey Data Easily with WPS Office

If building complex Power Automate flows is too time-consuming, you can easily export your Microsoft Forms responses and calculate weighted averages manually using WPS Spreadsheet. WPS Office is a free, lightweight, and fully compatible alternative to Microsoft Office.

1. Export Form Data: Download your Microsoft Forms responses as an Excel (.xlsx) spreadsheet.
2. Open with WPS Spreadsheet: Launch WPS Office and open the downloaded file containing your survey data.
3. Calculate Weights: Use built-in functions like SUMPRODUCT in WPS Spreadsheet to easily calculate weighted averages for your responses.

100% compatible with Microsoft Excel (.xlsx) formatsBuilt-in advanced formulas to easily calculate weighted averagesLightweight software with rapid startup timesFree to use with a familiar, zero-learning-curve interface

microsoft office alternative - wps office

Frequently Asked Questions

Will Microsoft Forms add native support for weighted questions?

Currently, Microsoft Forms does not provide a built-in feature for weighted questions. Users must rely on Power Automate integrations or manual spreadsheet calculations to achieve this.

Can I manually calculate weighted averages without Power Automate?

Yes. You can export your Microsoft Forms results directly to a spreadsheet program like Excel or WPS Spreadsheet, and use formulas to calculate the weighted scores manually.

Where can I get help building a flow for Microsoft Forms?

You can find tutorials, templates, and expert assistance in the official Microsoft Power Automate Community forums.

Office Quick Solutions