EXCEL考勤表数据如何统计?

2025-04-05 09:57:23
推荐回答(1个)
回答1:

AJ5公式:

=COUNTIFS(E$3:AI$3,"否",E$4:AI$4,"否",E5:AI5,"√")

下拉;

AK5公式:

=COUNTIFS(E$4:AI$4,"是",E5:AI5,"√")

下拉;

AL5公式:

=COUNTIFS(E$3:AI$3,"是",E5:AI5,"√")

下拉。