Microsoft Office Questions? Ask a IT Expert for Support ASAP
I am working in 2010 - I know I can just add the total row to the main table but I want to learn how to calculate between separate tables.Test1.docm
Thanks, ***** ***** don't want to total a bookmark total in table 1 and add that to a new total. I would like to add up all of the values in the row from a table and show the total in the separate table.
Charlie,Thank you for that clarification. And the only solution for that is to bookmark each cell in the other table and then you just call the bookmark names in the SUM funtion in the other table.For instance, the first table has 3 cells, bookmark each cell as t1b2, t1b3 and t1b4 (as a note for table 1 cell b2, and so on so that you can identify your bookmarks).Then in any of the cells in Table 2, you can use the formula:SUM(t1b2, t1b3,t1b4) to calculate the sum of the 3 cells.Just remember that bookmarks are just used to name a cell and you can use that name of the cell in formulas and Word will pull the value contained in that cell.Here is the modified sample:http://wikisend.com/download/613076/Test1_explained2.docmI hope that helped.Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated! If you need further assistance, please do not rate me negatively. Instead, please reply to me so that I can help you further.Thank you!Best regards,Jess