[Charlie Brown]

In Word 2003, I have created an evaluation form which has several separate
tables for each area being evaluated. The score of each area is placed in the
last cell of each table. The score is a text form field as a number between 1
and 3 or left blank.

At the end of the form I have placed another table for evaluation results.
In that table I am trying to average the scores using a formula.
Unfortunately the formula counts the blank fields when it is averaging, thus
giving an incorrect answer. My formula is simply this;

=AVERAGE(score1,score2,score3,score4,score5)

Any suggestions how to fix this would be greatly appreciated.

--
Charlie