RE: Excel & making formulas drawing from other worksheets
- From: "Chris Chaffin" <cchaffin@xxxxxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Thu, 28 Sep 2006 21:18:53 -0400
Hi there,
Lets say that on sheet3 you have three cells that you want to add
together and put the total on sheet1, your summary page.
The 3 cells that you want to add together is cells A5, C5, and F9
The formula would look something like this:
='sheet3'!A5+'sheet3'!c5+'sheet3'!f9
Notice that the name of the sheet is surrounded by an '.
If the cells you want to add together are connected like cells C5, C6,
and C7, then the formula would look like this:
=sum('sheet3'!C5:C7)
Any other questions, please feel free to send me a message off list.
Hope this helps,
Chris
cchaffin@xxxxxxxxxxxx
-----Original Message-----
From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On
Behalf Of Marvin Howdershell
Sent: Thursday, September 28, 2006 1:15 PM
To: jfw@xxxxxxxxxxxxx
Subject: Re: Excel & making formulas drawing from other worksheets
1. Copy the cell that you want displayed on the summary page with the
control - c command.
2. Go to the summary worksheet and highlight the cell where you want to
display the copied information.
3. Go to the edit menu and select the paste special item, press enter.
Control - tab once to the paste link button. Press the space bar.
You may find it interesting to review the formula that will appear in
the cell. That way you can manually type the formula in the future.
Good luck!
Marvin
----- Original Message -----
From: "Louis Lucero" <lclucero@xxxxxxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Thursday, September 28, 2006 9:55 AM
Subject: Excel & making formulas drawing from other worksheets
> Hi List,
> I am using Jaws 7.1 and Excel XP and cannot figure out how to navigate
> with Jaws when I am trying to make a formula using cells from other
> worksheets. I have a summary on the first worksheet and am wanting to
> add several cells that are located on another worksheet bringing the
> sum total to the summary page. Anybody have any ideas? Much thanks.
>
> Louis
>
>
> "Luck is a product of hard work."
> Louis A. Lucero
>
> --
> JFW related links:
> JFW homepage: http://www.freedomscientific.com/
> Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
> JFW List instructions:
> To post a message to the list, send it to jfw@xxxxxxxxxxxxx To
> unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
> Archives located at: //www.freelists.org/archives/jfw
>
> If you have any concerns about the list, post received from the list,
> or
the way the list is being run, do not post them to the list. Rather
contact the list owner at jfw-admins@xxxxxxxxxxxxxx
>
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
If you have any concerns about the list, post received from the list, or
the way the list is being run, do not post them to the list. Rather
contact the list owner at jfw-admins@xxxxxxxxxxxxxx
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
Other related posts:
