Subtracing in tables

G

Greg

Tiffany,

I never tried this before and I must admit that I was
stumped for awhile and still preplexed why the logical
expression won't work. Anyway, let's say your result is
in cell c12 of both tables. Select the entire first table
and use Insert>Bookmark and bookmark it Table1. Select
the second table and bookmark it Table2.

Use the formulat {=({=sum(Table1 c12)}-{=sum(Table2 c12)})}

-----Original Message-----
I want to know what the formula would be for subtracting
Click to expand...
one table's total from another. How do I bookmark them
correctly and use the bookmark name in the formula?
 

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

Similar Threads

Suming or dividing elements from different tables 2
formula field: don't display anything when value is zero (using ;" 5
Dsum and Dmax with structured references 1
Formula and Bookmark 4
Using a field to reference text in a bookmarked table 1
delete records in one table that occur in another table 0
SQL: Finding Data That Is In One Table But Not The Other 4
Duplicate record in Form and Subform 0

Top