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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
Excel does not accept text format! 0
Linking data in MS Word into Excel 5
drag formula down from columns that go acros 3
VLOOKUP or SUMIF for Multiple Criteria 2
Countif or other formula needed for multiple data/critera results 3
Autonumber field in Excel that behaves the same as Access 0
Need Help with a VBA subroutine 0

Top