在L1中输入或复制粘贴下列公式=COUNTIFS(C1:K1,">=0",C1:K1,"<=9")下拉填充条件格式，公式=AND(C1>=$A1,C1<=$B1)
L2=countifs(c2:k2,">="&min(a2:b2),c2:k2,"<="&max(a2:b2))公式下拉自动填充。标记用条件格式，条件为=and(c2>=min($a2:$b2),c2<=max($a2:$b2))
