How can I pull data from a different file from within a formula?
 

I'm trying to determine the number of shifts required to produce
widgets at our factory. We know the average speed that the widgets are
produced at. We know the quantity of widgets on order. We need to pull
the average speed for said widgets off of another spreadsheet (which is
on a shared network drive). The reason for this is so that when we
change our staffing levels, only one spreadsheet has to be updated (the
one with the average running speed).
Here's how I arrive at it, but I don't know how to sandwich the file
path into the formula:

Assuming a1, b1, and c1 have numbers in them...
d1 sums a1:c1 with the formula =sum(a1:c1)

Here's what I want:
=ROUNDUP(SUM(D1/Location Of File As Shown Below)/8,0)

I'm not sure if I should use
\ServerName\Directory Name\File Name.xls
OR
N:\Directory Name\File Name.xls (This is the mapped network drive path,
equivalent to the one listed above)

How do I get Excel to pull the data from the secondary file from within
the formula? And which way do I express the data path? Server name, or
mapped drive name?

I'm sorry if this isn't clear, but I am not quite sure how else to
express it.

Thanks in advance for any help!

Jim

How can I pull data from a different file from within a formula?
 

N:\Directory Name\File Name.xls

Use a cell for the value then

eg:

AA1="N:\FolderName\Filename.xls!A1"


=ROUNDUP(SUM(D1/AA1/8,0)


" wrote:

I'm trying to determine the number of shifts required to produce
widgets at our factory. We know the average speed that the widgets are
produced at. We know the quantity of widgets on order. We need to pull
the average speed for said widgets off of another spreadsheet (which is
on a shared network drive). The reason for this is so that when we
change our staffing levels, only one spreadsheet has to be updated (the
one with the average running speed).
Here's how I arrive at it, but I don't know how to sandwich the file
path into the formula:

Assuming a1, b1, and c1 have numbers in them...
d1 sums a1:c1 with the formula =sum(a1:c1)

Here's what I want:
=ROUNDUP(SUM(D1/Location Of File As Shown Below)/8,0)

I'm not sure if I should use
\ServerName\Directory Name\File Name.xls
OR
N:\Directory Name\File Name.xls (This is the mapped network drive path,
equivalent to the one listed above)

How do I get Excel to pull the data from the secondary file from within
the formula? And which way do I express the data path? Server name, or
mapped drive name?

I'm sorry if this isn't clear, but I am not quite sure how else to
express it.

Thanks in advance for any help!

Jim