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

[µo°Ý] ¦p¦ó­pºâ¥X¨â¦C¦@¦Pªº©M(2)

[µo°Ý] ¦p¦ó­pºâ¥X¨â¦C¦@¦Pªº©M(2)

ªíA

ABCDEFGH
1·|ij«ÇA·|ij«ÇB·|ij«ÇC®É¬q1®É¬q2¤H¼Æ·|­û«D·|­û
211401
311501
411201
511301
611251
7226011
83217512


ªíB
ABCDEF
®É¬q1®É¬q2·|­û«D·|­û¦U·|ij«Ç¨Ï¥Î¤H¼Æ
10·|ij«ÇA212185
11·|ij«ÇB3324185
12·|ij«ÇC011030

¦bhttp://forum.twbts.com/viewthread.php?tid=12904 ¤¤
¦bA2¦ÜC6½d³ò¤¤
¦]¨C®æÅã¥Üªº¦¸¼Æ¬°"1"
©Ò¥H«e½ú­Ì±Ð¾É¨Ï¥Î¥H¤U¤½¦¡­pºâ
F10=SUMPRODUCT(($A$2:$A$6=1)*($D$2:$D$6=1))

·Q°Ý°Ý­YªG¼Æ¦r(¦¸¼Æ)¦pB7©MB8
¥Ñ"1"Åܦ¨"2"©Î"3"
§Y¦¹¶µ¤½¦¡·|¥Ñ
F10=SUMPRODUCT(($A$2:$A$8=?)*($D$2:$D$8=?)

?¸Ó«ç¼Ë­×§ï

¦^´_ 1# K_Wing

¡@ª©­±2¤§¤½¦¡¸Ô¸Ñ¡A½Ð°Ñ¦Ò¡Ghttps://goo.gl/UxrT8W
   
E0125_1.png
2017-12-7 11:22

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_  K_Wing

¡@ª©­±2¤§¤½¦¡¸Ô¸Ñ¡A½Ð°Ñ¦Ò¡Ghttps://goo.gl/UxrT8W
joblyc017 µoªí©ó 2017-12-7 11:23

·PÁ¸ԺɪºÁ¿¸Ñ©M¦^ÂÐ
¤´­n®É¶¡ºCºC®ø¤Æ

TOP

hcm19522 µoªí©ó 2017-12-8 10:15

B18:C20=SUMPRODUCT(N(($A$1:$C$1=$A18)*$A$2:$C$8>0)*D$2:D$8)
­Y·Q²³æ¤@¨Ç
·Q°Ý°Ý¥i§_±Nºâ¦¡­×§ï¬°
­pºâ½dÃ¥¥u¥Î¤@­Ó·|ij«Ç­pºâ
·|ij«ÇA*®É¬q1*¨Ï¥Î¦¸¼Æ
¥i§_¦³³o¼Ëªººâ¦¡©O?

TOP

¬JµM¨S¦³®e©ö²z¸Ñªº¤èªk
°ß¦³±N©Ò¦³2©M3ªº¦¸¼Æ
¤À©î¦¨1ªº¦¸¼Æ­pºâ

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD