Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.tables,microsoft.public.word.newusers
LurfysMa LurfysMa is offline
external usenet poster
 
Posts: 86
Default Simple table calculation: Excel or ???

I need to put a cost estimate table in a Word (2007) document. The
table has 2 columns and a variable number of rows:

Hours Activity
7 Travel
21 Design
15 Review
43 Total hours
$3,225 Total cost

The next to last row has the total hours in column 1.

I would like the value in the last row, column 1, to be the product of
the total hours (cell just above) and some rate ($75 in the example).

I can get the both the sum and the product to work in a fixed table. I
put "=sum(above)" in cell A5 and "=A5*75" in cell A6.

The problem comes if I add (or delete) a row. The sum still works, but
the product has a hard cell reference.

Can I make it a relative cell reference?

If not, can I put in an Excel table instead that I can change in Word?
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple table calculation: Excel or ??? LurfysMa New Users 2 June 30th 07 01:06 AM
Calculation field from SQL table [email protected] Mailmerge 2 August 3rd 06 08:20 PM
Word Table Calculation VBA TomorrowsMan Tables 1 March 25th 06 08:12 AM
Table calculation problem bob engler Tables 1 December 18th 05 08:10 AM
Calculation in table Ray Tables 3 July 22nd 05 07:12 PM


All times are GMT +1. The time now is 06:16 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"