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

[µo°Ý] ½Ð°Ý¥Ñ¤é´Á­pºâÁ`¥Í²£¶q

[µo°Ý] ½Ð°Ý¥Ñ¤é´Á­pºâÁ`¥Í²£¶q

¥»©«³Ì«á¥Ñ PD961A ©ó 2010-8-2 13:48 ½s¿è

½Ð°Ý¦U¦ì¥ý¶i
¤½¦¡BL=SUMIF(M$14:N$207,$BK14)
­n­pºâ6/1¤é´ÁÁ`¥Í²£¶q..½Ð°Ý¤½¦¡­þ¸Ì¿ù»~
½ÐÀ°¦£­×¥¿
ÁÂÁÂ..


¥i¯à¬O¨ä¤¤¤@­Ó cell ¦³¤p¼Æ¦ì, ¨â­Ó cell ­n§¹¥þ¤@¼Ë¤~¤½¦¡¦¨¥ß.

TOP

¦^´_ 12# ivanyung


    ¤£¦n·N«ä
¬O§Úªº®æ¦¡¦³°ÝÃD¶Ü?©¹¤U½Æ»s·|¦³NGªº¦a¤è....

TOP

¬Ýº|¤F²´, ¤S¦A¤@¦¸¥¢»~
=if(t13=u13,"OK","ng")

TOP

¦^´_ 10# ivanyung



ÁÙ¬ONGªü...

TOP

¦^´_ 8# PD961A


    =if(and(t13=0,u13=0),"OK","ng")

TOP

¦^´_ 7# kimbal


    ¤µ¦¸¯u¥¢Â§

TOP

¥»©«³Ì«á¥Ñ PD961A ©ó 2010-8-3 11:24 ½s¿è

¦^´_ 7# kimbal
¦^´_ 6# ivanyung


    ÁÂÁÂivanyung
    ÁÂÁÂkimbalª©¥D
    (¤½¦¡kimbalª©¥D¬O¹ïªº)ÁÂÁÂ..

¥t¥~¦A½Ð°ÝU13=T13
¤½¦¡±a¥XNG
½Ð°Ý¸Ó¦p¦ó­×¥¿
ÁÂÁÂ...

TOP

¥»©«³Ì«á¥Ñ kimbal ©ó 2010-8-2 22:32 ½s¿è

¦^´_ 5# PD961A

»~¤¤°Æ¨®
    =SUMIF(M$14:M$222,$S13,H$14:H222)
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

=sumif(h14:m222,s13,h14:h222)

TOP

        ÀR«ä¦Û¦b : ¦³Ä@©ñ¦b¤ß¸Ì¡A¨S¦³¨­Åé¤O¦æ¡A¥¿¦p¯Ñ¥Ð¤£¼½ºØ¡A¬Ò¬OªÅ¹L¦]½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD