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

yeh199200

539.rar (7.42 KB)

¤U¸ü¦¸¼Æ: 14

2012-5-2 13:47

½Ð°Ý¤@¤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


ÁÂÁÂ:)

yeh199200

=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

yeh199200

¦^´_  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 ÁÂÁÂ

yeh199200

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

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

yeh199200

=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

ANGELA

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

register313

¦^´_ 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{ }

Hsieh

¦^´_ 1# yeh199200

¤U¸ü (16.08 KB)

2012-5-2 14:43