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

¤å¦r®æ¦¡Âà¦^¼Æ¦r®æ¦¡

¦^´_ 4# Hsieh

    ¤j¤j³o©Û[¿ù»~Àˬd¤u¨ã]ªºÀ³¥Î~ Åý¤p§Ì¾Ç¤F¤@©Û~
    ¥i¥H¥Î¨Ó¸Ñ¨M¦P¨Æ¦b³o¤@¤è­±ªº°ÝÃD
     ·P®¦­ò~~~  ^^
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

¦^´_ 1# enoch
¤£ª¾¹D§Aªº¥Î·N¦ó¦b?
µ{¦¡°Ïµo°ÝÀ³¸Ó¬O­n¥ÎVBA¨ÓÂà´«³o¨Ç¼Æ¦r«¬ªº¤å¦r
¦³®É­Ô¨Ã¤£¤@©w­n¥ýÂন¼Æ­È¤~¯àÀ³¥Î
Á|­Ó¨Ò¦pªG­n¥[Á`A1:A5
k = Evaluate("SUMPRODUCT((A1:A5)*1)")
³o¼Ëk­È¤@¼Ë¯à¦¨¬°20
¨Ã¤£»Ý­n¦bÀx¦s®æ¤ºÂà´«
¦pªG­n½T¹ê±NÀx¦s®æ¤ºªº¼Æ¦r«¬¤å¦rÂন¼Æ­È
°£¤F¸ê®Æ­åªR¡AÀ³¥Î¿ù»~Àˬd¤u¨ã¤]¬O«Ü¤è«Kªº
¸ê®Æ­åªR
play.gif
¿ù»~Àˬd¤u¨ã
play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 1# enoch

A1~A5 ®æ¦¡¥ý³]©w¬°³q¥Î
¦A¥Î¸ê®Æ­åªR

TOP

¦^´_ 1# enoch
¥i¿ý»s¥¨¶°¸Õ¸Õ¬Ý

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤H¤£©È¿ù¡A´N©È¤£§ï¹L¡A§ï¹L¨Ã¤£Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD