linking worksheets - PLEASE HELP!!!

greenday_ladie · Apr 3rd, 2002, 06:02 PM

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

daleyman · Apr 3rd, 2002, 06:06 PM

...something like...

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

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

daleyman · Apr 3rd, 2002, 06:09 PM

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 3rd, 2002, 06:02 PM	#1
greenday_ladie New Member Join Date: Apr 2002 Posts: 1	I need formula to get a total of items to a summary sheet from multiple cell ranges on multiple spreadsheets.

Apr 3rd, 2002, 06:06 PM	#2
daleyman Board Regular Join Date: Mar 2002 Location: London, UK Posts: 167	...something like... =SUM(Sheet3!F9:F21,Sheet1!K6:K16,Sheet5!D3:D8) ...keep adding expressions for all the sheet ranges you want.

Apr 3rd, 2002, 06:09 PM	#3
daleyman Board Regular Join Date: Mar 2002 Location: London, UK Posts: 167	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 ]