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. 


Thread Tools  Display Modes 
#1




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




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




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  


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 