Average

[Stephen]

Is there a smart way to calculate the average of an array
of %-increases and &-decreases? The normal average
function will only return an arithmic average, which will
not calculate the average correctly if there are negative
numbers in there. In order to calculate the geometrical
average (which does allow for negative numbers) I would
think GEOMEAN should be the correct function. This does
however not allow negative numbers? What alternatives do I
have?

Hope someone can help me.

Thanks,
Stephen

 

[CLR]

Maybe............=SUMIF(A1:A10,">0")/COUNTIF(A1:A10,">0")

Vaya con Dios,
Chuck, CABGx3