① 姹傜敤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)) ,鍏寮忎笅𨰾.
镊虫,涓涓灏忓瀷镄勮繘阌瀛樼郴缁熷氨寤虹珛璧锋潵浜.
褰撶劧,瀹为檯镄勬儏褰㈣繙杈冭繖涓澶嶆潅镄勫,鎴戜滑瀹屽叏鍙浠ュ湪杩欎釜锘虹涓,杩涗竴姝ュ畬锽勫拰镓╁𪾢,闾ｆ槸钖庤瘽,涓斾笉璇村畠.
