EXCEL中怎么实现多条件跨表格求和?
EXCEL中怎么实现多条件跨表格求和?
日期:2020-03-11 20:49:13 人气:1
假设你表2的员工在A列,款号在B列,工序在C列,有两种方法
1.
03版的EXCEL,则在表2输入=SUMPRODUCT((Sheet1!B$2:B$100=A2)*(Sheet1!C$2:C$100=B2)*(Sheet1!D$2:D$100=C2)*(Sheet1!E$2:E$100))
2.
07版以上的EXCEL,则在表2输入=SUMIFS(Sheet1!E:E,Sheet1!B:B,A2,Sheet1!C:C,B2,Sheet1!D:D,C2)