How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Jess M. Your Own Question

Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 6590
Experience:  Computer Software Specialist for more than 10 years
49766785
Type Your Microsoft Office Question Here...
Jess M. is online now

I want to insert for formula in to a table that will calculate

Resolved Question:

I want to insert for formula in to a table that will calculate from a separate table from within the same document. I tried to bookmark the table =SUM(Table 1 C2:C2) but it is not working
Submitted: 2 years ago.
Category: Microsoft Office
Expert:  Jess M. replied 2 years ago.
Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.

Are you doing this in a Microsoft Word document? Is it Word 2007, 2010 or 2013?
Also, can you send a dummy of that document to me so that I can check your requirement directly? If it is possible, please upload the dummy document to http://wikisend.com and the give me the 6-digit File ID so that I can get your sample file.


Best regards,
Jess
Customer: replied 2 years ago.

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

Expert:  Jess M. replied 2 years ago.
Charlie,

Thank you for writing back. I got the file. Please give me a moment to check your requirements.

Regards,
Jess
Expert:  Jess M. replied 2 years ago.
Charlie,

The formula you used in the sample file is incorrect. You cannot use the SUM function to add the referenced cell that is bookmarked.

Can I modify the sample file to show this and to also show how to calculate between tables?

Jess
Customer: replied 2 years ago.

Please do


 

Expert:  Jess M. replied 2 years ago.
Thanks. Please give me a moment.

Jess
Expert:  Jess M. replied 2 years ago.
Charlie,

Thank you for patiently waiting. Here is the completed sample for you:
http://wikisend.com/download/925362/Test1_explained.docm

I put there my explanation as to how to use a bookmarked cell in computing across tables. Please note that bookmarks are only used to name cells in this example so when you want to call that cell in the formula, you just need to enter the name of the bookmark in the formula.

I hope that helped.

Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated! Cool

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
Customer: replied 2 years ago.

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.

Expert:  Jess M. replied 2 years ago.

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.docm

I hope that helped.

Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated! Cool

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

Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 6590
Experience: Computer Software Specialist for more than 10 years
Jess M. and 3 other Microsoft Office Specialists are ready to help you

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    23
    A+ Comptia Certified computer repair
< Previous | Next >
  • http://ww2.justanswer.co.uk/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    23
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.co.uk/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.co.uk/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    241
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.co.uk/uploads/JA/JACUSTOMERf8udkdxk/2013-8-3_15150_323738101505074393259301621172992o.64x64.jpg KamilAnwar1's Avatar

    KamilAnwar1

    Office Specialist

    Satisfied Customers:

    122
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
  • http://ww2.justanswer.co.uk/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    111
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.co.uk/uploads/WI/Windowspcfix/2013-8-19_153826_ja12.64x64.jpg James K.'s Avatar

    James K.

    Consultant

    Satisfied Customers:

    110
    Technical Director of IT Company
  • http://ww2.justanswer.co.uk/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    56
    Bachelor's Degree in Information Technology, Microsoft Certified Professional
 
 
 

Related Microsoft Office Questions