作业帮excel2003 统计运算问题
来源：学生作业帮 编辑：作业帮 分类：综合作业 时间：2024/05/14 12:56:25
excel2003 统计运算问题
只要表1的H列、M列、R列、W列出现文字,相对应的D列、I列、N列、S列的数据被统计出来并相加,被表2的M列数据所减.
只要表1的H列、M列、R列、W列出现文字,相对应的D列、I列、N列、S列的数据被统计出来并相加,被表2的M列数据所减.
用SUMIF
=sum(Sheet2!M:M)-(SUMIF(M:M,"",D:D)+SUMIF(R:R,"",I:I)+SUMIF(R:R,"",N"N)+SUMIF(W:W,"",S"S))
SHEET2表示表2,根据实际修改
再问： 行不通啊？H\M\R\W是表一里的。
再答： 关键是你结果写在表1里还是表2里？ 表1里=sum(Sheet2!M:M)-(SUMIF(M:M,"",D:D)+SUMIF(R:R,"",I:I)+SUMIF(R:R,"",N"N)+SUMIF(W:W,"",S"S)) 表2里=sum(M:M)-(SUMIF(SHEET1!M:M,"",SHEET1!D:D)+SUMIF(SHEET1!R:R,"",SHEET1!I:I)+SUMIF(SHEET1!R:R,"",SHEET1!N"N)+SUMIF(SHEET1!W:W,"",SHEET1!S"S))
=sum(Sheet2!M:M)-(SUMIF(M:M,"",D:D)+SUMIF(R:R,"",I:I)+SUMIF(R:R,"",N"N)+SUMIF(W:W,"",S"S))
SHEET2表示表2,根据实际修改
再问： 行不通啊？H\M\R\W是表一里的。
再答： 关键是你结果写在表1里还是表2里？ 表1里=sum(Sheet2!M:M)-(SUMIF(M:M,"",D:D)+SUMIF(R:R,"",I:I)+SUMIF(R:R,"",N"N)+SUMIF(W:W,"",S"S)) 表2里=sum(M:M)-(SUMIF(SHEET1!M:M,"",SHEET1!D:D)+SUMIF(SHEET1!R:R,"",SHEET1!I:I)+SUMIF(SHEET1!R:R,"",SHEET1!N"N)+SUMIF(SHEET1!W:W,"",SHEET1!S"S))