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 |
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 |