ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¸Ó¦p¦ó²Î­p30­Ó¤u§@ªí¤¤¦³´X­Óoff?

[µo°Ý] ¸Ó¦p¦ó²Î­p30­Ó¤u§@ªí¤¤¦³´X­Óoff?

§Ú¥Îexcel»s§@¥X¶Ô¯Zªí ,¤@¤Ñ¤@­Ó¤u§@ªí¡C
¨S¥X¶Ôªº·|Åã¥Üoff
¦Ó§Ú­n«ç»ò²Î­p¥X30­Ó¤u§@ªí¤¤¡A¤p©ú¦³´X­Óoff ?

¥»©«³Ì«á¥Ñ luhpro ©ó 2015-1-30 23:00 ½s¿è
§Ú¥Îexcel»s§@¥X¶Ô¯Zªí ,¤@¤Ñ¤@­Ó¤u§@ªí¡C
¨S¥X¶Ôªº·|Åã¥Üoff
¦Ó§Ú­n«ç»ò²Î­p¥X30­Ó¤u§@ªí¤¤¡A¤p©ú¦³´X­Ó ...
v34antage µoªí©ó 2015-1-25 17:45

¤ñ¸û¶§¬Kªº¤èªk:
1. ·s¼W¤@­Ó²Î­p¤u§@ªí
2. ¨Ì§Ç¦b30­ÓÀx¦s®æ¤¤¿é¤J²Î­p¦U¤u§@ªíªº¤½¦¡ :
=COUNTIF(Sheet2!$A$1:$P$36,"off")
¨ä¤¤
Sheet2 ¨Ì¹ê»Ú¦U¤u§@ªí¦WºÙÅܧó
$A$1:$P$36 ¨Ì¹ê»Ú¶·²Î­pªºÀx¦s®æ°Ï°ì§@¬ÛÀ³ªº½Õ¾ã
³Ì«á±N¦U¤u§@ªí²Î­p¥X¨Óªº¼Æ¦r¬Û¥[§Y¥i.

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD