EXCEL公式分析=IF(A4="品名","",IF(ISERROR(INDIRECT(H$2&"!a1")),"",SUMIF(INDIRECT(H$2&"!3:3"),$A4,INDIRECT(H$2&"!15:15"))))

来源:学生作业帮助网 编辑:作业帮作业网 时间:2021/03/07 01:54:47
EXCEL公式分析=IF(A4="品名","",IF(ISERROR(INDIRECT(H$2&"!a1")),"",SUMIF(INDIRECT(H$2&"!3:3"),$A4,INDIRECT(H

EXCEL公式分析=IF(A4="品名","",IF(ISERROR(INDIRECT(H$2&"!a1")),"",SUMIF(INDIRECT(H$2&"!3:3"),$A4,INDIRECT(H$2&"!15:15"))))
EXCEL公式分析
=IF(A4="品名","",IF(ISERROR(INDIRECT(H$2&"!a1")),"",SUMIF(INDIRECT(H$2&"!3:3"),$A4,INDIRECT(H$2&"!15:15"))))

EXCEL公式分析=IF(A4="品名","",IF(ISERROR(INDIRECT(H$2&"!a1")),"",SUMIF(INDIRECT(H$2&"!3:3"),$A4,INDIRECT(H$2&"!15:15"))))
IF(A4="品名","",)这里表示如果A4单元格的内容为品名的话,就输出空格.否则继续后面IF的条件.
(INDIRECT(H$2&"!a1"))这里表示引用H$2和!a1这个单元格的值,ISERROR(INDIRECT(H$2&"!a1"))表示判断INDIRECT到的值是否正确.
IF(ISERROR(INDIRECT(H$2&"!a1")),"",SUMIF(INDIRECT(H$2&"!3:3"),$A4,INDIRECT(H$2&"!15:15"))))表示ISEEROR如果判断的结果为正确,则输入空格.输出SUMIF统计出来的结果.
SUMIF是一个条件加总的函数.这里是指将INDIRECT(H$2&"!3:3")中等于$A4的INDIRECT(H$2&"!15:15")进行相加.