Microsoft Excel question

General software, Operating Systems, and Programming discussion.
Everything from software questions, OSes, simple HTML to scripting languages, Perl, PHP, Python, MySQL, VB, C++ etc.
Post Reply
j0ey
Member
Posts: 62
Joined: Thu Jul 08, 2004 5:09 pm
Location: Central California

Microsoft Excel question

Post by j0ey »

I have two worksheets open. I need to get worksheet 2 to show me some totals from worksheet one. The "Insert function" key wont allow me sum from another worksheet. Can anyone some light on this?
Top
User avatar
ColdFusion
Posts: 3542
Joined: Mon Oct 30, 2000 12:00 am
Location: Vancouver, BC

Post by ColdFusion »

Its really simple. Use the function =<Sheet>!<cell>

Ex:

=Sheet1!A26

and manipulate it anyway you want:

=(Sheet1!A26 + A5)


Good luck.
Top
Post Reply

Return to “Software Forum”