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

[µo°Ý] ½Ð°Ý­n­pºâ½Æ»ùÀ³¥Î­þ­Ó¨ç¼Æ?

[µo°Ý] ½Ð°Ý­n­pºâ½Æ»ùÀ³¥Î­þ­Ó¨ç¼Æ?

¦ba2:a100 ¦sªº¬O«~¦W
¦bb2:b100 ¦sªº¬O¼Æ¶q
¦bc2:c100  ¦sªº¬O³æ»ù
a102»Pb102¬O¦X倂Àx¦s®æªº¤å¦r»¡©ú"½Æ»ù"
·Q¦bc102¥Î¨ç¼Æ­pºâ¥X =b2*c2+b3*c3+...+b100*c100
½Ð°Ý¸Ó¥Î¨º­Ó¨ç¼Æ?
¤@®É·Q¤£¨ì¤S«Ü«æ½Ð¤j¤jµ¹¤©«üÂI
·PÁÂ
Ann

=SUMPRODUCT(B2:B10,C2:C100)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁÂ
¤j¤jÄ@·N¦^µª³o­Ó²³æªº°ÝÃD
Ann

TOP

¦^´_ 3# ann


    «¢!¥u·|³oºØ²³æ°ÝÃD¡A¦b¤£µª´N¨S°ÝÃD¯àµªÅo!
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


     = = HªO¤j  ±z¦nÁ¾µê³á..

TOP

·|«h¤£Ãø,¤£·|´NÃø,¦pªG¤£°Ý,²³æªº°ÝÃD¤]·|·Ð¦n¤[ªº.¦Û¤vÆp¤û¨¤¦y,¤£¦p´£¥X¨Ó°Ý.¤£¬O¶Ü?

TOP

ı±o«Ü©¯¹Bµo²{³o¶é¦a
¤]«Ü·PÁÂ
¨C¦¸¦³°ÝÃD
³£¯à§Ö³t±o¨ìÀ°§U
Ann

TOP

¤j®v ±z¤Ö¥´¤@­Ó 0
¬O=SUMPRODUCT(B2:B100,C2:C100)

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD