- ©«¤l
- 967
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1001
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-11-29
- ³Ì«áµn¿ý
- 2022-5-17
|
¥»©«³Ì«á¥Ñ 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¦nn«öCtrl+Shift+Enter§@½T»{,¤½¦¡ªº«e«á·|¦Û°Ê¥[¤W{ } |
|