Calculating using formula outside a table

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top