Refer to Another Spreadsheet in a Formula

D

DOUG

How would I tell a formula to go to another spreadsheet and to take the sum
of a specified range?

DOUG
 
J

Jacob Skaria

Direct reference
=[Excelfile.xls]Sheet1!A1

Indirect reference
A1 = ExcelFile.xls
B1 = Sheet1
=INDIRECT("[" & A1 & "]" & B1 &"!" & "A1")

If this post helps click Yes
 
B

Bob Phillips

You precede the range with the sheet name and !, like so

=SUM(Sheet1!A1:A10)

or in single quotes if the shete name has spaces

=SUM('Some Sheet'!A1:A10)
 
D

Duke Carey

In the cell where you want the result, type;

=sum(

then press Ctrl-F6 to switch to the workbook containing the range to be
summed. Highlight the desired cells, and press Enter
 
Top