ªð¦^¦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

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD