=SUM(A1>PERCENTILE.INC($A$1:$A$20,20%),A1>PERCENTILE.INC($A$1:$A$20,40%),A1>PERCENTILE.INC($A$1:$A$20,60%),A1>PERCENTILE.INC($A$1:$A$20,80%))+1

应该有聪明的方法用Matrix公式把条件写成1段