Table with a Calculation Field and Dropdowns

  • Thread starter Thread starter Training Spec.
  • Start date Start date
T

Training Spec.

In the 4th column of my Table, I have 4 dropdown fields (scores of 1 to 5).
At the bottom of the 4th column, I have a Calculated field. I have tried
everyhting to get an Average of the 4 entries (dropdowns) in the cell. I
bookmarked the cells as "e,o,p and w" to represent the scores for Excel,
Outlook, PowerPoint and Word. Then I entered the formula =AVERAGE(e,o,p,w).
That did not work. Next, I tried this formula =AVERAGE(D1:D4). That produced
an error. I tried "Calculate on Exit" with the four dropdown and with/without
"Calculate on Exit" in the formula cell. Nothing works!

If I type in some numbers in the cells, the formula works fine.

Bottom Line: What is the formula for averaging four dropdown fields?

Here's a visual of the 3rd and 4th columns of my Table:
Excel (dropdown)
Outlook (dropdown)
PowerPoint (dropdown)
Word (dropdown)
Average (calculated field)

Thanks,
 
Hi John,

See my reply in microsoft.public.word.tables. Please don't post the same question separately in different newsgroups.

Cheers
 
Back
Top