hi sooz,

The error message relates to the reference to 'Table 3' in your formula.

Look in Insert|Bookmark to see if 'Table 3' is defined. Probably not, since
you can't have a space in a bookmark name.

If 'Table3' exists, change your field's bookmark reference to that and see
how you get on.

If you still have a problem, use Edit|Goto|Bookmark|Table3 and check that
the bookmark encompasses a table and that cells A10 and C10 actually exist.
If cells A10 and C10 exist, make sure the bookmark includes them. If not,
you may have to delete the bookmark, select the whole table and re-insert
the bookmark. Then try your field again - should work now.

Cheers


"sooz" wrote in message
...

Thanks, I appreciate your help
However I'm still not clear on what I need to do... (I've had no
experience with bookmarks by the way).
I've pressed Alt F9 and an example of the formula which appears in one
of the cells is:

}
=PRODUCT(
Table 3
A10,C10)\#
"$#,###.00"}

So I've added in new formulas to the two new rows (I didn't copy them
this time) and altered them so A10 is A11 and A12 and C10 is C 11 and
C12.
But I still get the bookmark error.
How can I tell if bookmarks are being used?
Hope someone can help

sooz


--
sooz