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/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
_______________________________________________
Jfw mailing list
[email protected]
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com
