Simple table calculation: Excel or ??? LurfysMa <invalid[ at ]invalid.invalid> 6/27/2007 6:31:24 AM 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?

Re: Simple table calculation: Excel or ??? "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 6/27/2007 8:56:29 AM 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" <invalid[ at ]invalid.invalid> wrote in message news:3a0483th7oemjd2es1a1mqacsv8g4tpf04[ at ]4ax.com... [Quoted Text] >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?

RE: Simple table calculation: Excel or ??? Tom Conrad 6/30/2007 12:06:09 AM 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: [Quoted Text] > 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? >