Thu, 5 Jul 2007 15:46:01 -0700 from RcWend
:
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?

=SUM(...) / COUNTIF(... <0)
--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/