On 2002-03-19 14:18, Markscozz wrote:
Does anyone know how to calculate the average of a range of numbers, excluding zeros?
On 2002-03-19 14:18, Markscozz wrote:
Does anyone know how to calculate the average of a range of numbers, excluding zeros?
On 2002-03-19 14:24, Aladin Akyurek wrote:
On 2002-03-19 14:18, Markscozz wrote:
Does anyone know how to calculate the average of a range of numbers, excluding zeros?
There are a few formulas for computing the average of non-zero values in a range:
=SUM(A1:A9)/MAX(1,COUNTIF(A1:A9,">0")+COUNTIF(A1:A9,"<0"))
to propose my preferred formula.
Aladin