"RcWend" wrote...
....
"RcWend" wrote:
This is the formula I have now in order to caculate the average sales
price
that each salesperson has sold their item for.
=AVERAGE('R:\Sales Forcast\Current Forecast\2008 Forecast\[Randy
Customers.xls]Randy Totals'!AK4,'R:\Sales Forcast\Current Forecast\2008
Forecast\[Lynn Customers.xls]Lynn Totals'!AK4,'R:\Sales Forcast\Current
Forecast\2008 Forecast\)
....

So you're pulling single values from multiple files? If so, don't try to
average them directly. You'd be MUCH better off pulling the values into
separate cells in your summary workbook, e.g.,

C3:
='R:\Sales Forcast\Current Forecast\2008 Forecast\[Randy Customers.xls]
Randy Totals'!AK4

C4:
='R:\Sales Forcast\Current Forecast\2008 Forecast\[Lynn Customers.xls]
Lynn Totals'!AK4

etc., then using a formula like

=SUM(C4:C#)/COUNTIF(C4:C#,"0")

where C# is a placeholder for the bottommost row in the range containing the
separate external reference links to the other files.