倒数最后十个数字且大于等于7的个数 (9000)

D3{=SUM(N(N(+OFFSET(B1,LARGE(IF(1-ISERR(0/B3:B23),ROW(3:23)),10)-1,,99))>6))

另解{=SUM(N(INDEX(B:B,N(IF({1,0},LARGE(IF(1-ISERR(0/B3:B23),ROW(3:23)),ROW(1:10)))))>6))

另解{=SUM(COUNTIF(INDIRECT("b"&LARGE(IF(COUNTIF(OFFSET(B2,ROW(1:21),),"<9e307"),ROW(3:23)),ROW(1:10))),">=7"))

另解=LOOKUP(10,COUNTIF(OFFSET(B23,,,-ROW(1:21)),{"<9e9",">6"}))

另解{=COUNTIF(B23:INDEX(B3:B23,LARGE((ROW(3:23)-2)*ISNUMBER(B3:B23)*(B3:B23<>""),10)),">=7")