D
DOUG
How would I tell a formula to go to another spreadsheet and to take the sum
of a specified range?
DOUG
of a specified range?
DOUG
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
=[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)
=SUM(Sheet1!A1:A10)
or in single quotes if the shete name has spaces
=SUM('Some Sheet'!A1:A10)
D
Don Guillett
spreadsheet means?
Workbook
worksheet
Workbook
worksheet
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
=sum(
then press Ctrl-F6 to switch to the workbook containing the range to be
summed. Highlight the desired cells, and press Enter