D31=SUMPRODUCT(N(OFFSET(D1,LOOKUP(9^9,D1:D30,ROW(1:30))-10,,10)=1))
或=COUNT(0/(OFFSET(D1,LOOKUP(9^9,D1:D30,ROW(1:30))-10,,10)=1))----数组公式
