Excel中统计请假次数并根据次数扣分,详细说明见下面?答:如图:AG2=COUNT(IF(IFERROR(IFERROR(SMALL(IF(B2:AF2="",COLUMN(B2:AF2)),COLUMN(B:AF)),"")-IFERROR(SMALL(IF(B2:AF2="",COLUMN(B2:AF2)),COLUMN(A:AE)),"")-1,"")<>0,IFERROR(IFERROR(SMALL(IF(B2:AF2="",COLUMN(B2:AF2)),COLUMN(B:AF)),"")-IFERROR(SMALL(IF(B2...