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

[µo°Ý] ½Ð°Ý EXCEL ­pºâ¦~°²¤Î¥[¯Z¤Î¿ð¨ì¤Î¯f°²¡H

[µo°Ý] ½Ð°Ý EXCEL ­pºâ¦~°²¤Î¥[¯Z¤Î¿ð¨ì¤Î¯f°²¡H

¥»©«³Ì«á¥Ñ lucky_jocky ©ó 2013-4-12 19:55 ½s¿è

download file: http://www.sendspace.com/file/2fv1q4



¦U¤è®v¥S¡A½Ð½ç±Ð¡C

F4<--¦p¦ó¦Û°Ê­pºâ??
F5<-- ¦p¦ó¥[¯Z¥H1¤p®É«á¦Û°Ê­pºâ¥H¤Î¦Û°Ê¦©´î¸É®É??
F6<--¦p¨Ï¥Î¦~°²¦p¦ó¦Û°Ê¦©´î¡H
F7<--¦p¦ó¦Û°Ê­pºâ??

PS: ¦pªG¦³¨ä¥L·N¨£¥iÀu¤Æ¥L¡A½ÐÀH«K­×§ï¡CÁÂÁ¡C
¦]¥»¤Hªº¿n¤À¥¼°÷¡A¤£¯à¤U¸ü¤å¥ó¡A½Ð¸Ô²Ó±Ð¾É¡C ·P¿E,·P¿E¡C

¥»©«³Ì«á¥Ñ Bodhidharma ©ó 2013-4-13 01:26 ½s¿è

¦^´_ 1# lucky_jocky


F4°}¦C¤½¦¡
=SUM(IF(E16:E430="¿ð¨ì",F16:F430,0))
F5°}¦C¤½¦¡
=SUM(IF(E16:E430="¥[¯Z",F16:F430,0))-SUM(IF(E16:E430="¸É®É",F16:F430,0))
(³oÃä¼Æ¶q·|¸ò§A­ì¥»ªº¤£¤@¼Ë¡A¦]¬°§A3/21¥[¯Z5¤p®É¨S¦³¦C¦b"²Î­p"Àx¦s®æ¤¤¡AµM«á·í¦~¥[¯Z11¤p®É¡A¸É®É9¤p®É¡AÀ³¸Ó·|¬O2¤p®É¡A§A³o®æ¬O­n¥[¤W¥h¦~ªº²Ö­p¡H
F6¬Ý¤£À´
F7°}¦C¤½¦¡
=SUM(IF(E16:E430="¯f°²",F16:F430,0))

TOP

¦^´_ 2# Bodhidharma

®Ú¾Ú§A©Ò´£¨Ñªº¤½¦¡
F4 = #VALUE!
F5 = #VALUE!
F7 = #VALUE!

½Ð°Ý¦p¦ó¸Ñ¨M??

F6 <--¦p¨Ï¥Î¦~°²¦p¦ó¦Û°Ê¦©´î¡H (¦]¬°¦b23/3 ½Ð¤F¦~°², ¥i¥H¦Û°Ê¦©´î¶Ü¡H

¦hÁ®v¥S¥X¤âÀ°¦£¡C

TOP

¦^´_ 3# lucky_jocky

°}¦C¤½¦¡½Ð¥Îctrl+shift+enter¿é¤J
F6¤@¯ë¤½¦¡=E6-COUNTIF(E16:E430,"¦~°²")

TOP

¦^´_ 4# Bodhidharma
©ú¥Õ¤F~~¯uªº¦n¦³®Ä, §A¤S¤@¦¸¸Ñµª§Úªº°ÝÃD°Õ~~·P¿E·P¿E~~

TOP

        ÀR«ä¦Û¦b : ­×¦æ­nô½t­×¤ß¡AÂǨƽm¤ß¡AÀH³B¾i¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD