Average Array Formula

[Rachael]

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),D1509: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

[Mangesh Yadav]

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

Mangesh



"Rachael" <[email protected]> wrote in message
news:[email protected]...
> 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),D1509: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
>
>
>

[Mangesh Yadav]

Sorry forgot to mention that this is an array formula.

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

Mangesh




"Rachael" <[email protected]> wrote in message
news:[email protected]...
> 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),D1509: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
>
>
>

[Rachael]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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),D1509: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
> >
> >
> >
>
>
>