Document Editing Problems

How to Calculate Scores from Multiple Drop-Down Lists in Word

Steve K Oct 10, 2026 868 views

Question details

The user needs to automatically calculate the total score of selected numeric answers from multiple drop-down menus within a Word questionnaire table.

How to Calculate Scores from Multiple Drop-Down Lists in Word

Product: Word
Device & OS: not provided
Scenario: Creating an interactive questionnaire or grading form in a document table where selected options correspond to numeric scores that must be totaled.
Observed behavior: Modern drop-down content controls do not automatically pass numeric values to Word formulas, requiring the use of legacy form fields, bookmarks, or VBA to successfully calculate a total.

Before you start

Ensure the Developer tab is enabled on your ribbon (File > Options > Customize Ribbon), as you will need access to Legacy Form tools to make automated field calculations work properly.

Solution 1Recommended

Use Legacy Drop-Down Form Fields and Field Formulas

Since modern content controls do not easily feed into formula calculations, using legacy drop-down fields combined with a SUM formula is the most reliable native method.

To calculate values based on drop-down selections, the document must utilize legacy form fields rather than the newer Content Controls. Legacy fields can be bookmarked and set to calculate on exit, allowing standard table formulas to read their numeric output.

Insert Legacy Drop-Down Fields

Navigate to the Developer tab, click the 'Legacy Tools' icon (a briefcase folder), and select 'Drop-Down Form Field' to insert it into your desired table cell.

Configure Drop-Down Options

Double-click the inserted drop-down field. Add your numeric score options in the 'Drop-down item' box and click 'Add'. Crucially, check the 'Calculate on exit' box and note the name in the 'Bookmark' field (e.g., Dropdown1).

Insert the Total Formula

Click into the table cell where you want the total score to appear. Press Ctrl+F9 to insert field braces { }. Inside the braces, type your formula, such as =SUM(A1:A3) if referencing table cells, or =Dropdown1+Dropdown2 if using bookmarks.

Update the Calculation

Press F9 while the formula field is selected to update the result. Once the document is restricted to filling in forms, changing a drop-down and exiting the field will automatically refresh this total.

Use Legacy Drop-Down Form Fields and Field Formulas

Table Cell Referencing: When your drop-down menus are contained inside a table, you can reference them just like Excel cells (e.g., A1 is the top-left cell, B2 is the second column and second row).

WPS Writer Solution

Build and Calculate Forms Effortlessly in WPS Writer

WPS Writer fully supports legacy form fields, bookmarks, and formula calculations, making it easy to create automated questionnaires and grading rubrics without complex coding or macros.

1. Open Forms Tool: Open your document in WPS Writer and navigate to the Insert tab to locate the Forms options.
2. Insert Form Fields: Insert a Drop-Down Form Field into your table cells. Double-click the field to define the numeric list options and ensure 'Calculate on exit' is enabled.
3. Apply Formula: Click inside your designated total cell, navigate to Table Tools, and select Formula. Input =SUM(ABOVE) or specific cell references (like =SUM(A1:A3)) to compute the final score.

Fully compatible with Microsoft Word document formats (.docx).Easy-to-use Forms tools for inserting drop-down lists and calculation fields.Built-in formula support for dynamic table calculations.Lightweight, free alternative for seamless document processing and automation.

microsoft office alternative - wps office

Frequently Asked Questions

Why isn't my total score updating automatically when I change a drop-down option?

Word formulas do not always calculate automatically in real-time. You must ensure the 'Calculate on exit' option is checked in the drop-down field's properties. Alternatively, you can manually select the formula field and press F9 to refresh the calculation.

Can I use modern Content Controls to calculate scores instead of legacy tools?

Modern Drop-Down List Content Controls store data as text and do not easily pass numeric values to standard field formulas. To use modern controls for mathematical calculations, you typically need to write a custom VBA macro to read the selected text values and compute the total.

How do I reference specific drop-down fields in my formula?

If your drop-downs are in a table, you can use standard table references like A1, B1 (where letters represent columns and numbers represent rows). Alternatively, you can assign a unique Bookmark name to each drop-down in its properties window and use a formula like =SUM(Question1, Question2).

Document & File Issues