- ©«¤l
- 209
- ¥DÃD
- 43
- ºëµØ
- 0
- ¿n¤À
- 262
- ÂI¦W
- 0
- §@·~¨t²Î
- win 7
- ³nÅ骩¥»
- office 20**
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-11-3
- ³Ì«áµn¿ý
- 2017-4-16
|
¥»©«³Ì«á¥Ñ tku0216 ©ó 2014-12-23 15:22 ½s¿è
¦^´_ 1# t8899
©_©Ç¡A§Ú¥Î¿z¿ï¬Ý¤F¤@¤U¡AÀ³¸Ó¬O¦³15µ§¸ê®Æ²Å¦X§Aªº°ÝÃD¡A¨£¤U¹Ï¡G
§Ú¬O¥Î¤½¦¡=COUNTIFS(K21:K99,">1",H21:H99,"<1")¡A¥i¥H±o¨ì15³oµª®×¡C
¥t¥~¡A±N½d³ò¼W¥[¨ìK21:K350»PH21:H350¡A¤@¼Ë·|±o¨ì15³oÓµª®×¡C |
|