Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-19-2020, 07:31 PM
macropod's Avatar
macropod macropod is offline calculate total of drop-down values in Word 2007 Windows 7 64bit calculate total of drop-down values in Word 2007 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,381
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Three issues:


1. Your formula fields lack the required space between 'REF' and 'Dropdown' (e.g. you have 'REFDropdown1' instead of 'REF Dropdown1');
2. You have employed typed braces (i.e. { }) instead of inserting field braces via Ctrl-F9, as a result of which you've also failed to maintained the required pairing (e.g. {= { REFDropdown1} +{REFDropdown2} +/#0} } instead of {= { REF Dropdown1} +{REF Dropdown2} \# 0}); and
3. You've messed up the numeric picture switch (e.g. +/#0 instead of \# 0)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 05-20-2020, 04:56 PM
jfb jfb is offline calculate total of drop-down values in Word 2007 Windows 10 calculate total of drop-down values in Word 2007 Office 2007
Novice
calculate total of drop-down values in Word 2007
 
Join Date: May 2020
Posts: 4
jfb is on a distinguished road
Default

Oh, I didn't realize that Ctrl + F9 go around each "REF Dropdown" expression. Now instead of Syntax Error, I'm getting: !Undefined Bookmark, CHOOSE. I've attached undated document.
jfb
Attached Files
File Type: docx Legacy Play Evaluation2.docx (16.0 KB, 9 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
calculate total of drop-down values in Word 2007 QA Table to Calculate Checked Items into Total Percentage artofanime Word Tables 1 10-15-2019 08:40 PM
calculate total of drop-down values in Word 2007 Calculate Field from Drop Down Results in Word for Mac 2011 acerie Word 8 11-11-2015 06:49 PM
Pivot Table - How to calculate from Grand Total field LoriD Excel 0 06-15-2015 07:05 PM
calculate average depending on drop-down values virencm Word 0 08-06-2010 06:10 PM
Word - Calculate and paste values from Excel sheet Augf87 Word 1 07-06-2009 10:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft