Table with a Calculation Field and Dropdowns

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,
 
M

macropod

Hi John,

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

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word 2007 Table with Calculation & Dropdown Fields 7
Calculate results of dropdown boxes in table 11
Problem with printing a word document containing a table 0
Need a Word Formula That References Text Dropdown Fields and Numeric Entries 1
Best way to display Mulitple comboboxes and dropdown boxes for a userform 0
Formula within Pivot Table Calculated Field - Days in time period 0
Create different dropdowns for same table column 1
Null values in word 2003 calculations 0

Top