Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Propagate Array Formula Down Column | Excel Discussion (Misc queries) | |||
array formulas-sumproduct and average | New Users to Excel | |||
Array formula help | Excel Discussion (Misc queries) | |||
How do I create a formula to calculate the average percentage rat | Excel Worksheet Functions | |||
array formula help | Excel Worksheet Functions |