平均 往上五個非空非0數字 (11201)

E2{=IF(D2="","",IFERROR(SUM(N(IF({1},INDIRECT("D"&LARGE(IF(D$2:D2>0,ROW($2:2)),5)&":D"&ROW()))))/5,""))

另解{=IF(E2="","",IFERROR(SUM(OFFSET(D2,,,-MATCH(5,SUBTOTAL(2,OFFSET(D2,,,-ROW($1:$10))),)))/5,""))

另解{=IF(D2="","",IFERROR(SUM(INDEX(D:D,LARGE(IF(D$2:D2,ROW($2:2)),5)):D2)/5,""))