'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Calculate Totals from Drop-Down Form Fields in Word
Question details
The user wants to automatically calculate and display the sum of numerical values selected from multiple drop-down form fields in a Word document.
- Product
- Word
- Device & OS
- not provided
- Scenario
- Creating a fillable form with drop-down lists where a total needs to be automatically calculated based on user selections.
- Observed behavior
- The user is trying to set up automatic calculation but lacks the 'Calculate on exit' option or is unsure how to properly configure the formula field.
Ensure your Developer tab is enabled in Word to access form controls, and decide whether you prefer automatic calculation using Legacy Forms or manual updates using Content Controls.
Use Legacy Drop-Down Form Fields for Automatic Calculation
This method is recommended because it allows the total to update automatically when the user exits a drop-down field, provided the document is restricted to form filling.
The 'Calculate on exit' functionality is exclusive to Legacy Form Fields. Modern Content Controls do not support this feature natively.
Go to the Developer tab, click the 'Legacy Tools' briefcase icon, and select 'Drop-Down Form Field' to insert it into your document.
Double-click the inserted drop-down field to open its Options. Add your numeric choices, assign a unique Bookmark name (e.g., 'First', 'Second'), check the 'Calculate on exit' box, and click OK.
Click where you want the total to appear and press Ctrl+F9 to insert a field code bracket. Type an equals sign followed by your bookmark names separated by plus signs, for example: { = First + Second + Third }.
Go to the Developer tab, click 'Restrict Editing', check the box under 'Editing restrictions', choose 'Filling in forms' from the drop-down menu, and click 'Yes, Start Enforcing Protection'. The calculation will now trigger automatically upon field exit.
Use Content Controls and Manually Update Totals
If you must use modern Drop-Down List Content Controls, you will need to manually refresh the total formula or utilize a VBA macro, as they lack the automatic 'Calculate on exit' option.
Create and Calculate Fillable Forms Easily in WPS Writer
WPS Office provides robust and intuitive Developer tools for creating interactive, fillable forms. You can easily insert legacy drop-down lists, set bookmarks, and configure formulas to automatically calculate totals in your documents.
- 1. Enable the Developer Tab: Open your document in WPS Writer. If the Developer tab is not visible, go to Menu > Options > Customize Ribbon and enable 'Developer'.
- 2. Insert and Configure Drop-Downs: Under the Developer tab, select 'Drop-Down Form Field' from the Forms toolbar. Double-click it to add numeric values, set a Bookmark, and check 'Calculate on exit'.
- 3. Insert Formula and Protect: Press Ctrl+F9 to insert your sum formula (e.g., { = Value1 + Value2 }). Finally, click 'Protect Document' in the Developer tab and restrict it to form filling.
Frequently Asked Questions
Why is the 'Calculate on exit' option missing in my Word drop-down?
The 'Calculate on exit' option is exclusive to Legacy Form Fields. If you are using modern Drop-Down List Content Controls, this checkbox will not be available in the properties menu.
How do I show the Developer tab to insert form fields?
Go to File > Options > Customize Ribbon. In the right-hand pane, check the box next to 'Developer' and click OK. The Developer tab will now appear on your main ribbon.
Why isn't my formula field updating automatically when I change a drop-down value?
For automatic updates, ensure you are using Legacy Form Fields with 'Calculate on exit' checked, and verify that your document editing is restricted strictly to 'Filling in forms'.
Can I automatically update Content Control totals without pressing F9?
Yes, but it requires VBA. You can write a Document_ContentControlOnExit macro in a macro-enabled document (.docm) to force the formula field to update whenever a user leaves the content control.
