excelªº«e½úÌ
¤u§@ªí Sheet2 B , C , O , P Äæ³]¦³¨ç¼Æ , ¥i¥H§â¥¦Ì¥Hµ{¦¡¥N½Xªº¤è¦¡³B²z¶Ü ?
BÄæ³]¨ç¼Æ¦p¤U
=IF(A2<> "",VLOOKUP($A$2:$A$409,¸ê®Æ!$A$1:$C$64,2,FALSE), "")
CÄæ³]¨ç¼Æ¦p¤U
=IF(B2<> "",VLOOKUP($A$2:$A$409,¸ê®Æ!$A$1:$C$64,3,FALSE), "")
OÄæ³]¨ç¼Æ¦p¤U
=IF(AND(COUNTIF($A$2:$A2,$A2)=1,SUMIF($A$2:$A$301,$A2,$D$2)),SUMIF($A$2:$A$301,$A2,$D$2),"")
PÄæ³]¨ç¼Æ¦p¤U
=IF(AND(COUNTIF($E$2:$E2,$E2)=1,SUMIF($E$2:$E$301,$E2,$D$2)),SUMIF($E$2:$E$301,$E2,$D$2),"")
ÁÂÁÂ |