The formula that worked was: =+'sheet 1'!e6+'sheet 1'!e9
The cell in sheet 2 where you type the formula displays the results. -----Original Message----- From: Jfw [mailto:[email protected]] On Behalf Of Kevin Hourigan via Jfw Sent: Sunday, November 23, 2014 8:27 AM To: Sameer; The Jaws for Windows support list. Subject: Re: Formulas in excel. Hello Excellers, I tried this for entertainment, and received the comments "Ref has formula" or "Name has formula"; What would I enter to receive the actual number of the sum, please? Cheers Kevin. -----Original Message----- From: Sameer via Jfw Sent: Saturday, November 22, 2014 12:00 PM To: Greg Nickel ; The Jaws for Windows support list. Subject: Re: Formulas in excel. If you are adding two cells of one sheet & showing the total in another sheet, the sheet name should precede both the cell references. The formula should be =+'Sheet 1'!E6+'Sheet 1'!E9 Regards Mr. Sameer Latey, Mumbai, India -----Original Message----- From: Greg Nickel via Jfw Sent: Sunday, November 23, 2014 12:42 AM To: [email protected] Subject: Formulas in excel. Your excel knowledge is needed! I'm trying to link cells from one worksheet to another and at the same time add the values of cells on that first work sheet reflected as a sum on sheet 2. So.what I have so far is: =+'sheet 1'!e6+e9 It shows the value of e6 on sheet 2 but doesn't add e9 to it. How do I get the formula to add the contents of e6 and e9 from sheet 1? As always, many thanks to all of you. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/201411 22/40fe0bbe/attachment.html> _______________________________________________ Jfw mailing list [email protected] http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list [email protected] http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list [email protected] http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list [email protected] http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com
