A10单元格写入公式=COUNTIF(B2:B7,"<>空闲")或=COUNTIF(B2:B7,"<>空闲")-COUNTIF(B2:B7,"")
=COUNTA(B2:B7)-COUNTIF(B2:B7,"空闲")