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

K_Wing

ªíA

	A	B	C	D	E	F	G	H
1	·|ij«ÇA	·|ij«ÇB	·|ij«ÇC	®É¬q1	®É¬q2	¤H¼Æ	·|­û	«D·|­û
2	1			1		40	1
3		1		1		50		1
4	1				1	20	1
5			1		1	30	1
6	1			1		25		1
7		2			2	60	1	1
8		3		2	1	75	1	2

ªíB

	A	B	C	D	E	F
		®É¬q1	®É¬q2	·|­û	«D·|­û	¦U·|ij«Ç¨Ï¥Î¤H¼Æ
10	·|ij«ÇA	2	1	2	1	85
11	·|ij«ÇB	3	3	2	4	185
12	·|ij«ÇC	0	1	1	0	30

¦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=?)

?¸Ó«ç¼Ë­×§ï

joblyc017

¦^´_ 1# K_Wing

¡@ª©­±2¤§¤½¦¡¸Ô¸Ñ¡A½Ð°Ñ¦Ò¡Ghttps://goo.gl/UxrT8W
   

¤U¸ü (158.97 KB)

2017-12-7 11:22

hcm19522

http://blog.xuite.net/hcm19522/twblog/550667527

K_Wing

¦^´_  K_Wing

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

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

K_Wing

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?

K_Wing

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