水泥下单元个中输入:=SUMIFS(Sheet2!B2:B6,Sheet2!A2:A6,"C"&Sheet1!F7)
砂子下单元个中输入:=SUMIFS(Sheet2!C2:C6,Sheet2!A2:A6,"C"&Sheet1!F7)
石子下单元个中输入:=SUMIFS(Sheet2!D2:D6,Sheet2!A2:A6,"C"&Sheet1!F7)
粉煤灰下单元个中输入:=SUMIFS(Sheet2!E2:E6,Sheet2!A2:A6,"C"&Sheet1!F7)
水下单元个中输入:=SUMIFS(Sheet2!F2:F6,Sheet2!A2:A6,"C"&Sheet1!F7)
外加剂下单元个中输入:=SUMIFS(Sheet2!G2:G6,Sheet2!A2:A6,"C"&Sheet1!F7)
公式中后半部分是相同的Sheet2!A2:A6,"C"&Sheet1!
前面Sheet2!B2:B6,是引用表2中的数据
1水泥下单元
2 砂子下单元
3 SHEET2