Hi Steve,

I think there's something wrong with your formula - as posted, it can only
ever return 0.

As for the external referencing, some functions, including ABS, don't work.
However, you can get around this with:
{=(SUM(Tbl1 C9, Tbl1 C17, Tbl1 C25, Tbl1 J9, Tbl1 J17, Tbl1
J25) -6*39+ABS(SUM(Tbl1 C9)-39)+ABS(SUM(Tbl1 C17)-39)+ABS(SUM(Tbl1
C25)-39)+ABS(SUM(Tbl1 J9)-39)+ABS(SUM(Tbl1 J17)-39)+ABS(SUM(Tbl1
J25)-39))/2}
where Tbl1 is the bookmark name given to the reference table.

One of your later posts mentions the possibility of leaving the calculation
in a unused cell in the reference table, you only need to refer to that
cell. For example, if the formula appears in A30, you could use:
{=SUM(Tbl1 A30)}
or, if you bookmark just the formula (NOT the cell it's in), you could use:
{=BkMrk}
where 'BkMrk' is the name of the formula's bookmark.

Check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
for more info.

Cheers


"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