ªð¦^¦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¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD