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

½Ð°Ý³o¼ËªºÁ`­p¤½¦¡¥i¥H²¤Æ¶Ü??(¤w¸Ñ¨M)

½Ð°Ý³o¼ËªºÁ`­p¤½¦¡¥i¥H²¤Æ¶Ü??(¤w¸Ñ¨M)

¥»©«³Ì«á¥Ñ vackbin ©ó 2012-1-10 10:49 ½s¿è

½Ð°Ý¦U¦ì¤j¤j...
¤p§Ì±`±`°µ¨ì³o¼Ëªºªí®æ½Ð°Ý¥i¥H²¤Æ¤½¦¡¶Ü...¦]¬°ªí®æ¤j®É³£¹ï¨ì²´ªá¤F .@@
¨Ï¥ÎSUMPRODUCT¤S­n¨â°¼¹ïµ¥...¯u¬OÀYµhªü
[attach]9065[/attach]
»Ý¨D­pºâ-¤½¦¡Â²¤Æ.zip (1.9 KB)
Jack

¥»©«³Ì«á¥Ñ register313 ©ó 2012-1-4 21:45 ½s¿è

¦^´_ 1# vackbin

¦bEXCEL¤º ¸ê®Æªº§e²{À³ºÉ¶q¥H¸ê®Æ®w(ª½ªº¬°Äæ¦ì¦WºÙ ¾îªº¬°¦Uµ§¬ö¿ý)ªº¤è¦¡¨Ó§e²{¸û¦n
»Ý¨D­pºâ-¤½¦¡Â²¤Æ.zip (2.12 KB)

TOP

c9=SUMPRODUCT((B3:B6)*(C3:D6))

TOP

«x~~?§Ú¤]¬O¥ÎSUMPRODUCT´N¬O¥¢±Ñ??
¦ý¬O¤j¤jªº¤èªk³ºµMOK??!!
¤£¹LÁÙ¬O·PÁ¨â¦ì¤j¤j¼ö¤ß¸Ñµª
Jack

TOP

¥»©«³Ì«á¥Ñ vackbin ©ó 2012-1-10 10:49 ½s¿è

¸g¹L¤p§ÌÀˬd«á....­ì¨Ó§Ú¤S³Q¤å¦r®æ¦¡¥´±Ñ¤F  @@
Jack

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD