4.21号之后有出勤的,除强制调休以外的无请假的给200奖金,请4天以内的100奖金,4天以上的0
公式:
=IF(SUMPRODUCT((A4:A33>A24)*N(B4:B33="出勤"))>0,IF(COUNTIF(B4:B33,"请假")=0,200,IF(COUNTIF(B4:B33,"请假")<=4,100,0)),"21日后未出勤")