Excel: Average issue


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

72 80/88 100/113 125/138
UNDER 13 =COUNTIF(O5:O124,"<13") =COUNTIF(Q5:Q124,"<13") =COUNTIF(S5:S124,"<13") =COUNTIF(U5:U124,"<13")
UNDER 14 =COUNTIF(O5:O124,"<14") =COUNTIF(Q5:Q124,"<14") =COUNTIF(S5:S124,"<14") =COUNTIF(U5:U124,"<14")
UNDER 15 =COUNTIF(O5:O124,"<15") =COUNTIF(Q5:Q124,"<15") =COUNTIF(S5:S124,"<15") =COUNTIF(U5:U124,"<15")
TOTAL ENTRIES =COUNTIF(O5:O124,">0") =COUNTIF(Q5:Q124,">0") =COUNTIF(S5:S124,">0") =COUNTIF(U5:U124,">0")
% UNDER 13 =IFERROR(B35/B38,0) =IFERROR(C35/C38,0) =IFERROR(D35/D38,0) =IFERROR(E35/E38,0)
% UNDER 14 =IFERROR(B36/B38,0) =IFERROR(C36/C38,0) =IFERROR(D36/D38,0) =IFERROR(E36/E38,0)
% UNDER 15 =IFERROR(B37/B38,0) =IFERROR(C37/C38,0) =IFERROR(D37/D38,0) =IFERROR(E37/E38,0)
[FONT=Arial Narrow]Pressures 72 80/88 100/113 125/138 Average
Max =MAX(O5:O124) =MAX(Q5:Q124) =MAX(S5:S124) =MAX(U5:U124) =IFERROR(AVERAGEIF(B4:E4,">0",B4:E4),0)
Min =MIN(O5:O124) =MIN(Q5:Q124) =MIN(S5:S124) =MIN(U5:U124) =IFERROR(AVERAGEIF(B5:E5,">0",B5:E5),0)
Average =IFERROR(AVERAGEIF(O5:O124,">0",O5:O124),0) =IFERROR(AVERAGEIF(Q5:Q124,">0",Q5:Q124),0) =IFERROR(AVERAGEIF(S5:S124,">0",S5:S124),0) =IFERROR(AVERAGEIF(U5:U124,">0",U5:U124),0) =IFERROR(AVERAGEIF(B6:E6,">0",B6:E6),0)
Below psi Average
Under 13 =B39 =C39 =D39 =E39 =IFERROR(AVERAGEIF(B8:E8,">0",B8:E8),0)
Under 14 =B40 =C40 =D40 =E40 =IFERROR(AVERAGEIF(B9:E9,">0",B9:E9),0)
Under 15 =B41 =C41 =D41 =E41 =IFERROR(AVERAGEIF(B10:E10,">0",B10:E10),0)
[/FONT]


This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of October 10, 2013.


For more resources for Microsoft Excel