Average Array Formula
 

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

=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

Sorry forgot to mention that this is an array formula.

=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

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

Best wishes.

Rachael

"Mangesh Yadav" wrote:

Sorry forgot to mention that this is an array formula.

=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