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

sumproductªº°ÝÃD?

sumproductªº°ÝÃD?

¦pªþÀÉ,¨ä¹ê§Ú¤]¤£½T©w¯à¤£¯à¥Îsumproduct°µ¥X

§Ú·Q½Ð°Ýªº¬O²Ä¤G­Ótable¶À¦â®Ø®Øªº³¡¤À«ç»òºâ¥X?¨ä¥LªºÄæ¦ì§Ú¤w§Q¥Îsumif¥[Á`,EÄæ¶À¦âªº³¡¤À¬O§Æ±æ¥Î¥[Åv¥­§¡ªº·§©À¨ú±o¨C­Ósegmentªº¥­§¡purchase yield.Á|¨Ò¨Ó»¡, TW OLDªºpurchase yield­pºâ¬° (c6*e6+c7*e7+c8*e8) / (c6+c7+c8).

©Î³\³o«Ü²³æ,¦ý§Úªá¤F¤£¤Ö®É¶¡Á٧䤣¥X²³æªº¤èªk.½Ð¦U¦ìÀ°À°¦£,ÁÂÁÂ

Book1.rar (4.07 KB)

Jeffrey Chen

E13=SUMPRODUCT(($A$2:$A$11=A13)*$C$2:$C$11*$E$2:$E$11)/SUMPRODUCT(($A$2:$A$11=A13)*$C$2:$C$11)

TOP

¾Ç²ß¤F,ÁÂÁÂangela¤j
Jeffrey Chen

TOP

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD