Good afternoon,
I have a problem... I am hoping someone can help.
I have a spread-sheet which contains various codes in Column C (30,40,90,95,99) and value of percentage in Column G.
I want to take the values 30, 40 and average all amounts including 0% and I also want to include values 90, 95, 99 but with a value greater than 0% (not include 0%)
Currently I have it calculating everything greater than 0%
=AVERAGEIFS($G$2:$G$109,$C$2:$C$109,"<>30",$G$2:$G$109,">0") <<this works but omits any 0%
A B
<colgroup><col span="6"><col></colgroup><tbody>
</tbody>
Basically when I average this I filter anything containing a 90, 95, 99 and delete all 0% then average like normal... want something faster.
Thank you
I have a problem... I am hoping someone can help.
I have a spread-sheet which contains various codes in Column C (30,40,90,95,99) and value of percentage in Column G.
I want to take the values 30, 40 and average all amounts including 0% and I also want to include values 90, 95, 99 but with a value greater than 0% (not include 0%)
Currently I have it calculating everything greater than 0%
=AVERAGEIFS($G$2:$G$109,$C$2:$C$109,"<>30",$G$2:$G$109,">0") <<this works but omits any 0%
A B
WLKITL | WLDOCO | WASRST | WADRQJ | WLUORG | WLSOQS PERCENTAGE | |
Part | 1434671 | 99 | 07/31/18 | 630 | 630 | 100.00% |
1434672 | 99 | 08/01/18 | 900 | 900 | 100.00% | |
1434673 | 90 | 08/02/18 | 630 | 630 | 100.00% |
<colgroup><col span="6"><col></colgroup><tbody>
</tbody>
Basically when I average this I filter anything containing a 90, 95, 99 and delete all 0% then average like normal... want something faster.
Thank you