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