hi,
not entire sure what you have in mind but yes. it involves putting the file
path to the other file in the formula'
If the other file has totals already you might use somthing like this....

=('S:\PUBLIC\Ae-pc\WOM\FY03\[WorkOrderMonitoring Jan.xls]MPX'!$A$4)

this will bring the contents of a cell to your WB.
if no totals in the other file, this might work....

=SUM('S:\PUBLIC\Ae-pc\OM\FY03\[WorkOrderMonitoring Jan.xls]MPX'!$Z$4:$Z$500)

Careful. the last fomula wrapped.

Good luck

FSt1




"NoviceIan" wrote:

> Hi all,
>
> I have several seperate spreadsheets all in the same format and I was
> wondering if it would be possible to create another to total up the contents
> of the current lot. Is this possible?
>
> It has to be a seperate spreadsheet to avoid unnecessary complication for
> other staff.
>
> Thanks Ian