Excel如何自动指定出差次数?

2025-03-11 07:03:36
推荐回答(2个)
回答1:

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

=COUNTIF(B2:B7,"<>空闲")-COUNTIF(B2:B7,"")

回答2:

=COUNTA(B2:B7)-COUNTIF(B2:B7,"空闲")