IF function – is there a way to avoid repeating formula

You can force an error like #DIV/0! and then use IFERROR, e.g.

=IFERROR(1/(1/SUMIFS_formula),"")

Leave a Comment