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

¥X²{³s¸¹ªº¦¸¼Æ

¥X²{³s¸¹ªº¦¸¼Æ

¥»©«³Ì«á¥Ñ yeh199200 ©ó 2012-5-2 14:17 ½s¿è

539.rar (7.42 KB) ½Ð°Ý¤@¤U
¦p¦óºâ¥X³s¸¹ªº¦¸¼Æ

¤ñ¦p¦bsheet2ªºD24 ¥X²{ ³s¸¹(1,2)¦¸¼Æ©O? »yªk =COUNTIF(Sheet1!$D:$H,C25) .AND. COUNTIF(Sheet1!$D:$H,D25)¦¹»yªk¦n¦V¿ù»~
¸ê®Æ¦bsheet1 D:H


ÁÂÁÂ:)

¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-5-2 14:43 ½s¿è

¦^´_ 1# yeh199200

¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ register313 ©ó 2012-5-2 14:40 ½s¿è

¦^´_ 1# yeh199200

D24=SUM(((Sheet1!D6:D109=B24)+(Sheet1!E6:E109=B24)+(Sheet1!F6:F109=B24)+(Sheet1!G6:G109=B24)+(Sheet1!H6:H109=B24))*((Sheet1!D6:D109=C24)+(Sheet1!E6:E109=C24)+(Sheet1!F6:F109=C24)+(Sheet1!G6:G109=C24)+(Sheet1!H6:H109=C24)))
©Î
D24=SUMPRODUCT(((Sheet1!D6:D109=B24)+(Sheet1!E6:E109=B24)+(Sheet1!F6:F109=B24)+(Sheet1!G6:G109=B24)+(Sheet1!H6:H109=B24))*((Sheet1!D6:D109=C24)+(Sheet1!E6:E109=C24)+(Sheet1!F6:F109=C24)+(Sheet1!G6:G109=C24)+(Sheet1!H6:H109=C24)))

°}¦C¤½¦¡:¤½¦¡¿é¤J¦n­n«öCtrl+Shift+Enter§@½T»{,¤½¦¡ªº«e«á·|¦Û°Ê¥[¤W{ }

TOP

=SUMPRODUCT((Sheet1!D6:G109=B24)*(Sheet1!E6:H109=C24))

TOP

=SUMPRODUCT((Sheet1!D6:G109=B24)*(Sheet1!E6:H109=C24))
ANGELA µoªí©ó 2012-5-2 14:48

ÁÂÁ¦^´_ ¤£¹Lºâ¥X¨Ó¦n¹³¦³¿ù
®Ú¾Ú§Úªº¸ê®Æ ¦P®É¥X²{1,2 À³¸Ó¬O2¦¸
¥i¬O±zªº¤½¦¡­pºâ¥X¨Ó¬°0

TOP

[ª©¥DºÞ²z¯d¨¥]
  • Hsieh(2012-5-2 18:53): ¹Ï¤ù´Nºâ³X«È¤]¯à¬Ý¨ì

¦^´_  yeh199200
Hsieh µoªí©ó 2012-5-2 14:34

ªO¤j ±zªºÀÉ®× ¤p§ÌÅv­­¤Ó§C µLªk¨ú¥Î

TOP

¦^´_  yeh199200

D24=SUM(((Sheet1!D6109=B24)+(Sheet1!E6:E109=B24)+(Sheet1!F6:F109=B24)+(Sheet1! ...
register313 µoªí©ó 2012-5-2 14:36



    ·PÁ¦^À³ ±zªº¸ê®Æ°ª²` ¤p§Ì­n¬ã¨s¬ã¨s ÁÂÁÂ

TOP

=SUMPRODUCT((Sheet1!D6:G109=B24)*(Sheet1!E6:H109=C24))
ANGELA µoªí©ó 2012-5-2 14:48


ÁÂÁ±z
§Ú¦n¹³§ä¨ì¿ù»~ªº¦a¤è
­ì¥ý SUMPRODUCT((Sheet1!D6:G109=B24)*(Sheet1!E6:H109=C24))

­n§ï¬°SUMPRODUCT((Sheet1!D6:G109=B25)*(Sheet1!E6:H109=C25))

³o¼Ë¦n¹³´N¹ï¤F

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD