linking worksheets - PLEASE HELP!!!

[greenday_ladie]

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

 

[daleyman]

...something like...

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

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

 

[daleyman]

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