我需要创建公式的帮助！我希望公式包含#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",(Assignment!$E$3:$E$577=$B$3))),(WENN($B$4="dontcare",(Assignment!$E$3:$E$577=$B$4))),(WENN($B$5="dontcare",(Assignment!$E$3:$E$577=$B$5))),(WENN($B$6="dontcare",(Assignment!$E$3:$E$577=$B$6))))*(WENN($B$7="dontcare",(Assignment!$F$3:$F$577=$B$7)))*(WENN($B$8="dontcare",(Assignment!$B$3:$F$577=$B$8))),(Assignment!G$3:G$577)))),1)