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

[µo°Ý] SUMPRODUCTªº°ÝÃD

[µo°Ý] SUMPRODUCTªº°ÝÃD

=SUMPRODUCT((¥Ò=A2)*(¤A="¹O´Á"))
¥X²{ #N/A
¥Ò©M¤A³£¬O³]©wªº°ÊºA¦WºÙ
¦pªG¥Î©T©wªº½d³ò
=SUMPRODUCT((A1:A10=A2)*(B1:B10="¹O´Á"))
´N¥i¥H±o¨ìµª®×
­þ¦ì¥ý¶i¥i§_À°§ÚÄÀºÃ ÁÂÁÂ

¦^´_ 1# pinklee
½T»{°ÊºA½d³òªº©w¸q½d³ò¤j¤p¬O§_¬Û¦P
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh

ÁÂÁÂ!!¶¶«K½Ð±Ð¤@¤U
=OFFSET(Sheet1!$A$6,0,0,COUNT(Sheet1!$A:$A),1)

=OFFSET(Sheet1!$B$6,0,0,COUNT(Sheet1!$B:$B),1)

    ³o¨â°ÊºA½d³ò  ¬°¦ó·|¦³¤£¦Pªº¤j¤p

·PÁÂ

TOP

¦^´_ 3# pinklee


    ¨º­n¬Ý§Aªº¸ê®ÆAÄæ¸òBÄ檺¸ê®Æ§t¼Æ­Èªº¼Æ¶q¬O§_¬Ûµ¥ªü
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD