Reply
 
Thread Tools Display Modes
  #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?
  #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?



  #3   Report Post  
Posted to microsoft.public.word.newusers,microsoft.public.word.tables
Tom Conrad Tom Conrad is offline
external usenet poster
 
Posts: 88
Default Simple table calculation: Excel or ???

Tom C replied:

LurfysMa

Take a look at the following article:
Article: How to get a formula field to total an entire table column, even if
some cells in the column contain text or are blank.

By Dave Rado

http://word.mvps.org/FAQs/TblsFldsFms/TotalColumn.htm

This article suggests two methods to achieve the effect you desire within
Word without embedding an Excel spreadsheet. Both methods use a mixture of
bookmarks and field codes.

The numbers to be summed are placed in a data table (Table01), and the
formulae are placed into a summation table.

The tables are separated by a blank paragraph. The article specifies a line
height for the paragraph. I would also recommend the font size should be set
to 1pt.

The total numbers of rows in table 01 can be varied with out disrupting the
formulae.

Tom C

=== "LurfysMa" wrote:

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?

Reply
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
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 09:12 AM
Table calculation problem bob engler Tables 1 December 18th 05 09:10 AM
Simple question on cutting and pasting into Word from Excel Alex Microsoft Word Help 1 August 13th 05 02:00 PM
Calculation in table Ray Tables 3 July 22nd 05 07:12 PM


All times are GMT +1. The time now is 12:39 PM.

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"