A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Simple table calculation: Excel or ???



 
 
Thread Tools Display Modes
  #1  
Old June 27th 07, 07:31 AM posted to microsoft.public.word.tables,microsoft.public.word.newusers
LurfysMa
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?
Ads
  #2  
Old June 27th 07, 09:56 AM posted to microsoft.public.word.tables,microsoft.public.word.newusers
Doug Robbins - Word MVP
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  
Old June 30th 07, 01:06 AM posted to microsoft.public.word.newusers,microsoft.public.word.tables
Tom Conrad
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?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
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:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.