linking worksheets - PLEASE HELP!!!
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: linking worksheets - PLEASE HELP!!!

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I need formula to get a total of items to a summary sheet from multiple cell ranges on multiple spreadsheets.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    ...something like...

    =SUM(Sheet3!F9:F21,Sheet1!K6:K16,Sheet5!D3:D8)

    ...keep adding expressions for all the sheet ranges you want.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    when you say "spreadsheets" i assumed you meant worksheets on the same workbook.

    if the ranges are on worksheets on different workbooks then that is also possible using

    'C:[book1.xls]Sheet1'!$D$6:$D$9 ...for each range

    where C: is the filepath
    book1.xls is the filename

    [ This Message was edited by: daleyman on 2002-04-03 17:10 ]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com