View Single Post
  #4  
Old June 5th, 2004, 12:22 PM
macropod
external usenet poster
 
Posts: n/a
Default Formulas: Subtracting totals of different tables

If the 'total' on each of the two tables is the sum of all cells above,
you could use a formula coded like:

{=SUM(Table3 B:B)/2+SUM(Table4 B:B)/2}
where the braces are created via Ctrl-F9.

For more information on Word field maths, see:
http://www.wopr.com/cgi-bin/w3t/show...&Number=365442
(url all one line)

Cheers


---
Message posted from http://www.ExcelForum.com/