本帖最后由 feedyu 于 2012-11-18 13:50 编辑
【新手201203】07版第6讲作业-B32-feedyu.xlsx
少做了两题,现在补上:- {=SUM(SUMIFS(C32:C52,A32:A52,{"A"},B32:B52,{1,3,4}))+SUM(SUMIFS(C32:C52,A32:A52,{"C"},B32:B52,{1,3,4}))}
复制代码- =SUMPRODUCT((A32:A52={"A"})*(B32:B52={1,3,4})*C32:C52)+SUMPRODUCT((A32:A52={"C"})*(B32:B52={1,3,4})*C32:C52)
复制代码- =SUM(SUMIFS(C32:C52,A32:A52,{"A"},B32:B52,{1,3,4}))+SUM(SUMIFS(C32:C52,A32:A52,{"B"},B32:B52,{1,3,4}))+SUM(SUMIFS(C32:C52,A32:A52,{"C"},B32:B52,{1,3,4}))
复制代码- =SUMPRODUCT((A32:A52={"A"})*(B32:B52={1,3,4})*C32:C52)+SUMPRODUCT((A32:A52={"B"})*(B32:B52={1,3,4})*C32:C52)+SUMPRODUCT((A32:A52={"C"})*(B32:B52={1,3,4})*C32:C52)
复制代码 |