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

[µo°Ý] ¦³ÃöSUMPRODUCT???

[µo°Ý] ¦³ÃöSUMPRODUCT???

1.¤½¦¡1=SUMPRODUCT((Sheet1!S$C$67:$C$89=Sheet2!$A$29)*1,(Sheet1!$M$67:$M$89=Sheet2!$E34)*1,(Sheet1!$B$67:$B$89))
   ¤½¦¡2=SUMPRODUCT((Sheet1!$C$67:$C$89=Sheet2!$A$29)*(Sheet1!$M$67:$M$89=Sheet2!$E34)*(Sheet1!$B$67:$B$89))
   ½Ð°Ý¤½¦¡1¤Î¤½¦¡2ªº®t²§???¨â¤½¦¡¬O§_¦³¤£¦Pªº¨Ï¥Î®É¾÷??
2.¬°¦ó©óSheet2¤u§@ªí¤¤±N¦¹¤½¦¡½Æ»s¦Ü¦PÀɮפ§¥t¤@¤u§@ªí(Sheet3)¡A«hÀx¦s®æÅã¥Ü¬°0???

¦^´_ 1# pampam
³o¨â­Ó¤½¦¡À³¸Ó·|±o¨ì¦P¼Ëµ²ªG
²Ä¤@­Ó¤½¦¡¥u¤£¹L¬O¥ý±N2­ÓÅÞ¿è­È°}¦CÂন0»P1ªº°}¦C(¹êÄݦh¦¹¤@Á|)
½Æ»s¤½¦¡«á±o¨ì¤£¦Pµ²ªG¥i¯à¦]¬°¦¹¬q¤¤Sheet1!$M$67:$M$89=Sheet2!$E34
¦]¬°E34±Ä¥Î¦Cªº¬Û¹ï°Ñ·Ó¡A¾É­P½Æ»s«á°Ñ·Ó¿ù»~
¦pªG¤W¶ÇÀɮפñ¸û¯à¤F¸Ñ½T¹ê°ÝÃD©Ò¦b
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¤w¤W¶ÇÀɮסA¨ä°ÝÃD½Ð¸ÔS1 ¤u§@ªí¡A

ÁÂÁ¤j¤j­@¤ß¸Ñµª!

§÷®ÆÁ`ªí.rar (7.73 KB)

TOP

¦^´_ 3# pampam

AÄæ¨Ã«D¥¿½T¤é´Á¡A·|³Q»~§P¦¨¦r¦ê
½Æ»s¨ì¨ä¥L¤u§@ªí·|²£¥Í¿ù»~¡A¬O¦]¬°¨Ï¥Î¥~³¡°Ñ·Ó'S1'!$A$2ªº½t¬G
¸Õ¸Õªþ¥ó
B2=IF($C2="","",LOOKUP(2,1/((§÷®Æ!$L$4:$L$14=$C2)*(§÷®Æ!$B$4:$B$14=$A$2)),§÷®Æ!$A$4:$A$14))
D2=IF($C2="","",LOOKUP(2,1/((§÷®Æ!$L$4:$L$14='S1'!$C2)*(§÷®Æ!$B$4:$B$14='S1'!$A$2)),§÷®Æ!$K$4:$K$14))
E2=IF($C2="","",SUM($D$1:D2))
F2=IF($C2="","",LOOKUP(2,1/((§÷®Æ!$L$4:$L$14='S1'!$C2)*(§÷®Æ!$B$4:$B$14='S1'!$A$2)),§÷®Æ!$M$4:$M$14))
§÷®ÆÁ`ªí.rar (7.73 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD