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
|
|||
|
|||
Formula to Sum values in word table
Hi,
I have a table in word that contains numeric values (the cells in the table actually hold merge codes, but the data source populates all these cells with numeric values once the merge is done). Outside of the table, I then have a formula that I thought would sum the values in the second column of the table. The formula is {=SUM(Table1 b:b)} Note that I created a bookmark to the table named Table1. When I run the merge, the fields in the table all merge properly, but the formula displays the formula text as above, almost as if word ignores that it is a formula. But it definitely appears as a formula in the main document. I am pretty new to bookmarks and formulas in Word, so I am hoping that my problem is easy to solve. Thanks, Craig ps The below I pulled from a very helpful document on formulas in Word that I found through this newsgroup. Thought it might be helpful for others to see, since I used it to build my template. Only the following functions can accept references to table cells as arguments from outside that table: AVERAGE(), COUNT(), MAX(), MIN(), PRODUCT(), and SUM(). When referencing cell values in a table from outside that table, set up a bookmark for the table (Table1, say), then use the a suitable function (even for a single cell) to retrieve the table values (e.g. {=SUM(Table1 C1)} or {=SUM(Table1 A3)+SUM(Table1 B3)}). |
#2
|
|||
|
|||
Formula to Sum values in word table
If you created the bookmark in the mailmerge main document, it will not have
survived the mailmerge. Therefore, the reference to Table1 in the formula will be meaningless. Apart from that, did you use Ctrl+F9 to insert the field delimiters { } -- 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 "Craig" wrote in message ... Hi, I have a table in word that contains numeric values (the cells in the table actually hold merge codes, but the data source populates all these cells with numeric values once the merge is done). Outside of the table, I then have a formula that I thought would sum the values in the second column of the table. The formula is {=SUM(Table1 b:b)} Note that I created a bookmark to the table named Table1. When I run the merge, the fields in the table all merge properly, but the formula displays the formula text as above, almost as if word ignores that it is a formula. But it definitely appears as a formula in the main document. I am pretty new to bookmarks and formulas in Word, so I am hoping that my problem is easy to solve. Thanks, Craig ps The below I pulled from a very helpful document on formulas in Word that I found through this newsgroup. Thought it might be helpful for others to see, since I used it to build my template. Only the following functions can accept references to table cells as arguments from outside that table: AVERAGE(), COUNT(), MAX(), MIN(), PRODUCT(), and SUM(). When referencing cell values in a table from outside that table, set up a bookmark for the table (Table1, say), then use the a suitable function (even for a single cell) to retrieve the table values (e.g. {=SUM(Table1 C1)} or {=SUM(Table1 A3)+SUM(Table1 B3)}). |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Specific text placement | Nospam | New Users | 9 | October 11th, 2005 01:23 AM |
Can Wordperfect templates be converted to Word template docs | Terrill | New Users | 2 | September 14th, 2005 09:14 PM |
is word perfect compatible with office word? | Noreen | General Discussion | 1 | May 11th, 2005 11:17 PM |
Boiletplates from Word Perfect | linda | General Discussion | 1 | January 28th, 2005 05:37 PM |
Continuous breaks convert to next page breaks | Jennifer Hunt | General Discussion | 2 | December 30th, 2004 05:45 PM |