200高分悬赏excel，wps表格函数或公式，

Question

目标效果如图，计算带计算式和标注的表达式值，表达式为空时输出0
题主现在能实现第一行的统计 ，实现公式为
=EVALUATE(SUBSTITUTE(SUBSTITUTE(Sheet1!$B19,"[","*ISTEXT("""),"]",""")"))+EVALUATE(SUBSTITUTE(SUBSTITUTE(Sheet1!$C19,"[","*ISTEXT("""),"]",""")"))
问题在于怎么实现第二行不输入0的情况下，依然能输出

Answer 1

你的表格需要稍微改一下样式

Answer 2

最简单的就是加个IF判断，但公式有点长
=EVALUATE(SUBSTITUTE(SUBSTITUTE(IF(Sheet1!$B19="",0,Sheet1!$B19),"[","*ISTEXT("""),"]",""")"))+EVALUATE(SUBSTITUTE(SUBSTITUTE(IF(Sheet1!$C19="",0,Sheet1!$C19),"[","*ISTEXT("""),"]",""")"))本回答被提问者采纳