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\)
But between these 2 worksheets, there are some items one sales person has
sold & one has not & some both sales people have sold, but not necessarily
for the same price....I want to calculate the average price of an item
between the two, but not include the average if that salesperson has not sold
the item.
Can someone help?