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

¤½¦¡SUMPRODUCT

¤½¦¡SUMPRODUCT

§Ú¦bN11Äæ¼g¤F"=SUMPRODUCT(($D$9:$D$41=M12)*($L$9:$L$41=M11)*$G$9:$G$41)",¥i¬O¥X²{#VALUE
¦ý¬OÀ³¸Ó­n¬O500,§Ú¬O­n§ì$D$9¨ì$D$41²Å¦XM12   ¥B    $L$9:$L$41²Å¦XM11  ¥[Á`  $G$9:$G$41 Book3.zip (36.93 KB)

½Ð±Ð¤½¦¡­þ¸Ì¦³¿ù¤F?

¥»©«³Ì«á¥Ñ AnitaHuang99 ©ó 2012-3-22 15:05 ½s¿è

¦pªG¬O­n¨D"Forecast Quantity", «Øij§ï¦¨
=SUMPRODUCT(($D$9:$D$41=M12)*($L$9:$L$41=M11),$G$9:$G$41)

Book3.zip (37.38 KB)

TOP

¦^´_ 1# VANESSA

¼Æ­È°}¦C¤£¯à¥]§t¤å¦r
=SUMPRODUCT(($D$10:$D$41=M12)*($L$10:$L$41=M11)*$G$10:$G$41)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

§ÚÀ´¤F,ÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD