I see the following formula floating around quite a bit: =SUM(VLOOKUP($A2,May!$A:$K,5,0),VLOOKUP(Sheet2!A2,June!A:K,5,0),+(VLOOKUP(Sheet2!A2,July!
確定! 回上一頁