Hi Deb,

The LEFT, RIGHT, ABOVE and BELOW parameters are all buggy - see my Word
Filed Maths 'tutorial' at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
for more details, and some possible work-arounds.

Cheers



"Deb" wrote in message
...
I set up a formula within a Word table "=AVERAGE(LEFT)" on a school pupil
report to help staff to quickly complete an average score. In most cases
the
boxes to the left contain a figure, sometimes a box may contain "n/a"
where a
grade is not applicable. Sometimes this formula seems to work, but others
it
does not and I am unable to establish any logical pattern.

Does anyone have any clues to what is wrong?