excel同時滿足兩個條件:excel滿足2個條件取值[朗讀]

如圖:c2單元格公式為:=sumproduct((sheet1!a$2:a$100=a2)*(sheet1!b$2:b$100=b2)*sheet1!c$2:c$100)。