用excel制作员工考勤表,出勤用A12病假用B12产假C12想在最后求和的时候分...答:L2单元格 =SUM((LEFT(B2:J2)="B")*IF(LEN(B2:J2)=1,,IF(B2:J2="",,RIGHT(B2:J2,LEN(B2:J2)-1)))M2单元格 =SUM((LEFT(B2:J2)="C")*IF(LEN(B2:J2)=1,,IF(B2:J2="",,RIGHT(B2:J2,LEN(B2:J2)-1)))N2单元格 =SUM((LEFT(B2:J2)="N")*IF(LEN(B2:J2)=1,,IF...