View Single Post
  #2   Report Post  
Posted to microsoft.public.word.tables,microsoft.public.word.newusers
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Simple table calculation: Excel or ???

From the Table section of the Insert Ribbon, you can insert an Excel
Spreadsheet into a Word Document.

That should allow you to do what you want.


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"LurfysMa" wrote in message
...
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?