Please look in the "Average" column. Is it possible to be able to include and NOT include the 0 as part of the average? I have included all of my formulas to help if necessary. Thank you very much
<tbody>
</tbody>
<tbody>
</tbody>
72<o></o> | 80/88<o></o> | 100/113<o></o> | 125/138<o></o> | |
UNDER 13<o></o> | =COUNTIF(O5:O124,"<13")<o></o> | =COUNTIF(Q5:Q124,"<13")<o></o> | =COUNTIF(S5:S124,"<13")<o></o> | =COUNTIF(U5:U124,"<13")<o></o> |
UNDER 14<o></o> | =COUNTIF(O5:O124,"<14")<o></o> | =COUNTIF(Q5:Q124,"<14")<o></o> | =COUNTIF(S5:S124,"<14")<o></o> | =COUNTIF(U5:U124,"<14")<o></o> |
UNDER 15<o></o> | =COUNTIF(O5:O124,"<15")<o></o> | =COUNTIF(Q5:Q124,"<15")<o></o> | =COUNTIF(S5:S124,"<15")<o></o> | =COUNTIF(U5:U124,"<15")<o></o> |
TOTAL ENTRIES<o></o> | =COUNTIF(O5:O124,">0")<o></o> | =COUNTIF(Q5:Q124,">0")<o></o> | =COUNTIF(S5:S124,">0")<o></o> | =COUNTIF(U5:U124,">0")<o></o> |
% UNDER 13<o></o> | =IFERROR(B35/B38,0)<o></o> | =IFERROR(C35/C38,0)<o></o> | =IFERROR(D35/D38,0)<o></o> | =IFERROR(E35/E38,0)<o></o> |
% UNDER 14<o></o> | =IFERROR(B36/B38,0)<o></o> | =IFERROR(C36/C38,0)<o></o> | =IFERROR(D36/D38,0)<o></o> | =IFERROR(E36/E38,0)<o></o> |
% UNDER 15<o></o> | =IFERROR(B37/B38,0)<o></o> | =IFERROR(C37/C38,0)<o></o> | =IFERROR(D37/D38,0)<o></o> | =IFERROR(E37/E38,0)<o></o> |
<tbody>
</tbody>
Pressures<o></o> | 72<o></o> | 80/88<o></o> | 100/113<o></o> | 125/138 <o></o> | Average <o></o> |
Max<o></o> | =MAX(O5:O124)<o></o> | =MAX(Q5:Q124)<o></o> | =MAX(S5:S124)<o></o> | =MAX(U5:U124)<o></o> | =IFERROR(AVERAGEIF(B4:E4,">0",B4:E4),0)<o></o> |
Min<o></o> | =MIN(O5:O124)<o></o> | =MIN(Q5:Q124)<o></o> | =MIN(S5:S124)<o></o> | =MIN(U5:U124)<o></o> | =IFERROR(AVERAGEIF(B5:E5,">0",B5:E5),0)<o></o> |
Average<o></o> | =IFERROR(AVERAGEIF(O5:O124,">0",O5:O124),0)<o></o> | =IFERROR(AVERAGEIF(Q5:Q124,">0",Q5:Q124),0)<o></o> | =IFERROR(AVERAGEIF(S5:S124,">0",S5:S124),0)<o></o> | =IFERROR(AVERAGEIF(U5:U124,">0",U5:U124),0)<o></o> | =IFERROR(AVERAGEIF(B6:E6,">0",B6:E6),0)<o></o> |
Below psi<o></o> | Average<o></o> | ||||
Under 13<o></o> | =B39<o></o> | =C39<o></o> | =D39<o></o> | =E39<o></o> | =IFERROR(AVERAGEIF(B8:E8,">0",B8:E8),0)<o></o> |
Under 14<o></o> | =B40<o></o> | =C40<o></o> | =D40<o></o> | =E40<o></o> | =IFERROR(AVERAGEIF(B9:E9,">0",B9:E9),0)<o></o> |
Under 15<o></o> | =B41<o></o> | =C41<o></o> | =D41<o></o> | =E41<o></o> | =IFERROR(AVERAGEIF(B10:E10,">0",B10:E10),0)<o></o> |
<tbody>
</tbody>