Average Array Formula

[Guest]

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)*(D15091519<>0),D15091519))}

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

 

[Mangesh Yadav]

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

Mangesh

 

[Mangesh Yadav]

Sorry forgot to mention that this is an array formula.

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

Mangesh

 

[Guest]

Thanks very much. I have used a variation of your formula suggestion.

Best wishes.

Rachael