google-sheets - 如何避免/绕过/忽略Google表格中的＃N/A #NV错误？

Question

我需要创建公式的帮助!我希望公式包含#NV错误，而忽略#NV错误。相反，即使存在#NV错误，也应输出一个值。您有什么想法吗？将错误的值插入“分配”列表时，将出现#NV错误。我该如何忽略呢？
=ARRAY_CONSTRAIN(ARRAYFORMULA(SUMME(WENN(ODER((WENN($B$2="dontcare",1,(Assignment!$E$3:$E$577=$B$2))),(WENN($B$3="dontcare",1,(Assignment!$E$3:$E$577=$B$3))),(WENN($B$4="dontcare",1,(Assignment!$E$3:$E$577=$B$4))),(WENN($B$5="dontcare",1,(Assignment!$E$3:$E$577=$B$5))),(WENN($B$6="dontcare",1,(Assignment!$E$3:$E$577=$B$6))))*(WENN($B$7="dontcare",1,(Assignment!$F$3:$F$577=$B$7)))*(WENN($B$8="dontcare",1,(Assignment!$B$3:$F$577=$B$8))),(Assignment!G$3:G$577)))), 1, 1)

Answer 1

将公式包装在IFERROR中

IFERROR(your-formula-here; "value if error here")