Re: Formulas in excel.

George B

You forgot the

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

-----Original Message-----
From: Jfw [] On Behalf Of Greg Nickel
via Jfw
Sent: Saturday, November 22, 2014 11:12
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

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...
Jfw mailing list

Join to automatically receive all group messages.