|
本帖最后由 东门吹雪 于 2012-9-2 10:23 编辑 <br /><br /><P>参考参考</P>
<P></P>
<P></P>
<P>[hide]</P>
<P></P>
<P>=IF(SUMPRODUCT((D6:AH6="事假")*1)>0,"事假"&SUMPRODUCT((D6:AH6="事假")*1)&"天","")&IF(SUMPRODUCT((D6:AH6="病假")*1)>0,"病假"&SUMPRODUCT((D6:AH6="病假")*1)&"天","")&IF(SUMPRODUCT((D6:AH6="旷工")*1)>0,"旷工"&SUMPRODUCT((D6:AH6="旷工")*1)&"天","")&IF(SUMPRODUCT((D6:AH6="加班")*1)>0,"加班"&SUMPRODUCT((D6:AH6="加班")*1)&"天","")&IF(SUMPRODUCT(OR(D6:AH6="事假",D6:AH6="病假",D6:AH6="旷工",D6:AH6="加班")*1)>0,"","出勤"&SUMPRODUCT((D6:AH6="出勤")*1)&"天")</P>
<P>[/hide<BR>]</P>
<DIV align=right><FONT color=#000066>[此贴子已经被作者于2009-10-2 18:56:41编辑过]</FONT></DIV> |
|