Thanks, Susan..but it just gives me an error message..anyone else?

"Susan" wrote:

try this (no guarantees it's completely correct!)

=SUM(...) / COUNTIF(... <0)


=SUM('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\) /COUNTIF(('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\) <0)

hth
:)
susan


On Jul 6, 11:24 am, RcWend wrote:
Thanks for the response, but still don't understand. Can you please put it
into the formula I have?



"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\)
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?- Hide quoted text -

- Show quoted text -