I have a long IF statement and need to return blank so I can use those cells for another statement

Dmills958 

It's better to wrap your initial formulas with IFERROR() to return zero or empty text instead of errors. SUM() ignores all texts.

But if you need to show errors you may use something like =AGGREGATE(9,6,range) to sum ignoring errors.