Calculate Field from Drop Down Results in Word for Mac 2011

[acerie]

Hello,

For Word for Mac version 2011:

I have 5 dropdown lists (bookmark "DD1" to "DD5", in which I have marked "calculate on exit") with numerical values in consecutive columns ("C1" to "C5") in a table. I want for the final column "C6" to be the sum all of these values.

In C6 I am inserting a formula field and trying to use the following :

- "= REF DD1 + REF DD2"


- "= DD1 + DD2"
- "{= {REF DD1}+{REF DD2}}
- "= {REF DD1}+{REF DD2}"
- "= {DD1}+{DD2}"

And none of these are working. Either there are syntax errors or it says that the references don't exist in the table....

HOWEVER, if I use a REF field instead of a formula field and just reference "REF DD1", I get the actual value that has been selected in the dropdown. So, obviously the bookmark does work.

Can you help me to find the proper way to go about this?

Furthermore, if it is possible, I would like for my dropdown list to display percentages rather than a simple number (i.e. "5%", rather than just "5".)

Kind regards,
Alix