Average issue

[CherryMan]

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

 

[Aladin Akyurek]

Below PSI	Size 1	Size 2	Size 3	Size 4	Average
Under 13	95%	0%	78%	5%
Under 14	100%	23%	93%	13%
Under 15	100%	45%	95%	25%

<tbody>
</tbody>

Lets try this: If size 1 cells B2:B4 are greater than 0 the below 13,14,15 must include the number in its calculation. If ALL the numbers B2:B4 are 0, then the below 13,14,15 CANNOT include the 0 in its calculation. So the average for the under 13 should include the number 0 in its calculation, because the numbers in C3 and C4 are greater than 0. If, say, all of the numbers C2:C4 are 0, then the average calculation CANNOT include the 0.

Still no results in the average column you want to see.

Am I confusing you more yet?

Indeed, I'm still far from having an idea of the task.