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

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

¥»©«³Ì«á¥Ñ 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

        ÀR«ä¦Û¦b : Ä@­n¤j¡B§Ó­n°í¡B®ð­n¬X¡B¤ß­n²Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD