用vlookup就行在b里，B1列写=VLOOKUP(A:A,'[a.xls]Sheet1'!$A:$B,1,0)
=SUMIFS([a.xlsx]sheet1!$B:$B,[a.xlsx]sheet1!$A:$A,A1)用这个就可以了
