Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / June 2007

Tip: Looking for answers? Try searching our database.

Sorting

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
talltom - 11 Jun 2007 23:08 GMT
I would like to ask how to write a formula to summarize info on a separate
worksheet within the current workbook.  

Example: Info is on Sheet 1 in C1 & C2, and Sheet 1 in E1 & E2, and I want
to display on Sheet 2 A1 & A2, and Sheet 2 A4 & A5, with a blank row
between A2 & A4 the numbers that are on Sheet 1

Sheet1!
On my list of numbers, I first copied and pasted 200 #'s in B1, and in C1
wrote
the formula =SUM(B1), then in C2 I wrote =SUM(B200), and repeated this 150
times.

Then on Sheet2 so I could print all 150 pairs of answers on one sheet to
easily reference.  

I wrote the following example starting in B1, repeated this 12 times to get
all 150 pairs of answers.  I wrote Down 13 sets of 3 rows, then over to the
right starting in D1, D2, etc.

Column A1                   Column B1
      1                           =SUM(Sheet1!B1) and
                                   =SUM(Sheet1!B2)
A4 is a Blank Row
      2                           =SUM(Sheet1!D1) and
                                   =SUM(Sheet1!D2)
Etc.

I was looking for an easier way to get the info from Sheet1! and Sheet2!
onto my summary sheet;   Sheet3!

This took me about 2 hours.  I hope there is an easier way to do this.

Sorry for being so wordy.
Peo Sjoblom - 11 Jun 2007 23:19 GMT
No need for sum if you only want to link a cell from another sheet, you can
just copy the cell(s), then do edit>paste special and select link

Signature

Regards,

Peo Sjoblom

>I would like to ask how to write a formula to summarize info on a separate
> worksheet within the current workbook.
[quoted text clipped - 32 lines]
>
> Sorry for being so wordy.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.