Subtracing in tables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Greg (anonymous_at_discussions.microsoft.com)
Date: 06/02/04 

Date: Wed, 2 Jun 2004 09:43:21 -0700

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
one table's total from another. How do I bookmark them
correctly and use the bookmark name in the formula?
>
>Thanks
>.
>

Relevant Pages