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

½Ð°Ýsumproduct¥i¥H§â«D¼Æ­È·í¦¨0¶Ü

½Ð°Ýsumproduct¥i¥H§â«D¼Æ­È·í¦¨0¶Ü

½Ð°Ýsumproduct¥i¥H§â«D¼Æ­È·í¦¨0¶Ü

°²³]=sumproduct(a1:a10,b1:b10)
¦ba7ªº¦a¤è¬O«D¼Æ­È
¦³¤èªk¥i¥HÅý¥¦µø¬°0¶Ü
¤£µM³£»Ý­n¤À¨â¬q¼g
=sumproduct(a1:a6,b1:b6)+sumproduct(a8:a10,b8:b10)
À³¥Î¤W·|¦³¨Ç³Â·Ð
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

À³¸Ó·|·í¦¨0­pºâªº¡A§A§â§Aªº¤å¥ó¶Ç¤W¨Ó¬Ý¬Ý¬O¬°¤°»ò¤£¦æ¡C

TOP

¶Ç¦^¦U°}¦C¤¤©Ò¦³¹ïÀ³¤¸¯À­¼¿nªºÁ`©M¡C

»yªk

SUMPRODUCT(array1,array2,array3, ...)

Array1, array2, array3, ...   ¬O 2 ¨ì 255 ­Ó±ý¨D¨ä¹ïÀ³¤¸¯À­¼¿n¤§©Mªº°}¦C¡C

³Æµù

¦U°}¦C¥²¶·¦³¬Û¦Pªººû«× (¬Û¦Pªº¦C¼Æ¡A¬Û¦PªºÄæ¼Æ)¡C§_«h SUMPRODUCT ¨ç¼Æ·|¶Ç¦^¿ù»~­È #VALUE!¡C
SUMPRODUCT ¨ç¼Æ·|±N©Ò¦³«D¼Æ­È¸ê®Æªº°}¦C¤¸¯À·í¦¨ 0 ¨Ó³B²z¡C
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD