Calculating using formula outside a table

  • Thread starter Thread starter makh
  • Start date Start date
M

makh

I have a table containing values. the table is bookmarked. Outside th
table, I want to show a value which has been calculated usin
non-contiguous fields (cells) from the table, so that I can writ
"Therefore we require £[formula] for this project" where [formula] ha
been created using the Table/Formula dialogue box as

=SUM(Table1 B7,C7,B8,C9,B11,C11)

This produces syntax errors. Any suggestions?:confused:

mak
 
Hi makh,

Try coding your formula as:
=SUM(Table1 B7, Table1 C7, Table1 B8, Table1 C9, Table1 B11, Table1 C11)

Cheers


makh said:
I have a table containing values. the table is bookmarked. Outside the
table, I want to show a value which has been calculated using
non-contiguous fields (cells) from the table, so that I can write
"Therefore we require £[formula] for this project" where [formula] has
been created using the Table/Formula dialogue box as

=SUM(Table1 B7,C7,B8,C9,B11,C11)

This produces syntax errors. Any suggestions?:confused:

makh
Click to expand...
 
Back
Top