I have book marked the table by clicking on the table anchor to highlight
the table and clicking form field options button on the forms toolbar and
then typing 'table1' in the bookmark box. I then, in the formula mentioned,
added table1 before every cell reference. but its still not working for
some reason. am I doing this right?

cheers

Steve

"Doug Robbins - Word MVP" wrote in message
...
From the Help file:

To reference cells in another table, or to reference a cell from outside a
table, identify the table with a bookmark (bookmark: A location or
selection of text in a file that you name for reference purposes.
Bookmarks identify a location within your file that you can later refer or
link to.). For example, the field { =average(Table2 b:b) } averages column
B in the table marked by the bookmark Table2.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"R.P.McMurphy" wrote in message
...
Hi all, can someone change this formula-

=(SUM(C9,C17,C25,J9,J17,J25)-6*39+ABS(C9-39)+ABS(C17-39)+ABS(C25-39)+ABS(J9-39)+ABS(J17-39)+ABS(J25-39))/2

to read from the cells in table1?

The form has two tables with form fields in, the first is the input
table, the second is the output or results table. The above works well
in a cell in the input table, but will not work in the output table, it
gives strange results!

Many Thanks!

Steve