Software

Ask something
Discussion Locked

MS Word Tables

0 helpful
7 replies

by tombird

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have 4 separate tables in MS Word. Three of them have a column of numbers with no total. In a cell on the 4th table I need the total of all the numbers. I have used bookmarks and they don't seem to be working.

Example:

Table1
5
6
7

Table2
1
2
3

Table3
8
9
10

Table4 any cell
Total of above numbers: 51

I have used the sum function but it won't accept bookmarks. Any help would be great.

7 replies

by peyison

The field in table 4 should look like:

{=sum(table1 a:a, table2 a:a, table3 a:a)}

A few things:

You probably know - to enter a field, select Insert -> Field, and in the text box, after the =, type in the formula above, without the curly braces.

To add a bookmark to a table, select the entire table, and add the bookmark.

You can right click on the cell with the formula to toggle the field codes on and off - and you need to right click on the formula and select Update Field to recalculate it after making changes.

This formula works - let me know if you're still having problems.

Hope this helps.

by c_m_s

Hi there,
The bookmark system works fine.
Highlight each table, one at a time, and bookmark it (table1, table2, table3). No spaces in the names now.
Enter your numbers into the cells you want (example column a).
In the fourth table select Table|Formula and in the formula blank enter
=Sum(table1 a:a, table2 a:a, table3 a:a) and OK it. The a:a tells Word where the numbers are to be summed.
If you would like an example I can e-mail you one.

Luck,
Mike

by c_m_s

Just an additional note. The a:a could also be written a1:a3, a cell range like in Excel. This allows you to reference each cell in the table individually.

by c_m_s

Sorry about duplicating Peyisons' response. Didn't see it when I posted my answer.

This discussion is closed to new replies.