Re: Formulas in excel.


George B
 

You forgot the

=+'sheet 1'!SUM(e6+e9)

-----Original Message-----
From: Jfw [mailto:jfw-bounces@lists.the-jdh.com] On Behalf Of Greg Nickel
via Jfw
Sent: Saturday, November 22, 2014 11:12
To: Jfw@lists.the-jdh.com
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
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com

Join main@jfw.groups.io to automatically receive all group messages.