① 奼傜敤EXCEL鍑芥暟鍏寮忓埗浣滅殑浠撳簱綆＄悊琛錛氬嚭搴撱佸叆搴撱佸簱瀛,鍙浠ヨ嚜鍔ㄥ埛鏂版暟鎹銆傝阿璋!
鐪嬩竴涓嬫垜榪欎釜,
紺烘剰鍥懼備笅(鍏4寮)
鍦<<浜у搧璧勬枡>>琛℅3涓杈撳叆鍏寮:=IF(B3="","",D3*F3) ,鍏寮忎笅鎷.
鍦<<鎬昏繘璐ц〃>>涓璅3涓杈撳叆鍏寮:=
IF(D3="","",E3*INDEX(浜у搧璧勬枡!$B$3:$G$170,MATCH(D3,浜у搧璧勬枡!$B$3:$B$170,0),3)) ,鍏寮忎笅鎷.
鍦<<鎬昏繘璐ц〃>>涓璆3涓杈撳叆鍏寮:=IF(D3="","",F3*IF($D3="","",INDEX(浜у搧璧勬枡!$B$3:$G$170,MATCH($D3,浜у搧璧勬枡!$B$3:$B$170,0),5))) ,鍏寮忎笅鎷.
鍦<<閿鍞鎶ヨ〃>>G3涓杈撳叆鍏寮:=IF(D3="","",E3*F3) ,鍏寮忎笅鎷.
鍦<<搴撳瓨>>涓瑽3鍗曞厓鏍間腑杈撳叆鍏寮:=IF(A3="",0,N(D3)-N(C3)+N(E3)) ,鍏寮忎笅鎷.
鍦<<搴撳瓨>>涓瑿3鍗曞厓鏍間腑杈撳叆鍏寮:=IF(ISNUMBER(MATCH($A3,閿鍞鎶ヨ〃!$D$3:$D$100,0)),SUMIF(閿鍞鎶ヨ〃!$D$3:$D$100,$A3,閿鍞鎶ヨ〃!$E$3:$E$100),"") ,鍏寮忎笅鎷.
鍦<<搴撳瓨>>涓璂3鍗曞厓鏍間腑杈撳叆鍏寮:=IF(OR(NOT(ISNUMBER(MATCH($A3,鎬昏繘璐у崟!$D$3:D$100,0))),A3=""),"",SUMIF(鎬昏繘璐у崟!$D$3:$D$100,$A3,鎬昏繘璐у崟!$F$3:$F$100)) ,鍏寮忎笅鎷.
鑷蟲,涓涓灝忓瀷鐨勮繘閿瀛樼郴緇熷氨寤虹珛璧鋒潵浜.
褰撶劧,瀹為檯鐨勬儏褰㈣繙杈冭繖涓澶嶆潅鐨勫,鎴戜滑瀹屽叏鍙浠ュ湪榪欎釜鍩虹涓,榪涗竴姝ュ畬鍠勫拰鎵╁睍,閭ｆ槸鍚庤瘽,涓斾笉璇村畠.
