Try this instead:
=SUM('Sheet1'!E1,E9)
Either that or you'll need to put the sheet reference on your E9 value too.> -----Original Message----- > From: Jfw [mailto:[email protected]] On Behalf Of Greg > Nickel via Jfw > Sent: Saturday, November 22, 2014 1:12 PM > 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/20141122/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
