=AVERAGE(IF(A1:A4=0,"",B1:B4))

Mangesh



"Rachael" wrote in message
...
I would like to calculate the Average Passed % (Column C).

0%s should only be included in the average calculation if the
corresponding
Total Number in Column A is more than 0.

Should it be something like this array formula?

{=AVERAGE(IF((B1509:B1519=0)*(D1509:D1519<0),D15 09:D1519))}

Please help.

Thanks & best wishes.

Rachael


Total Number Number Passed Passed % Number Failed
125 118 94% 7
0 0 0% 0
325 319 98% 5
105 103 98% 2
0 0 0% 0
1 0 0% 1