#REF! to Zero?

Hello Excellers,

I am wondering how to combine these two formulas together in one:

=SUMIF(D12488:D13009,""&X1,T12488:T13009)
and
=if(ISERROR(T13010,0,T13010)

and I want to apply this forumla to the entire column (T:T). Maybe there is a better way to write this instead of combining the codes above?

Thanks!!

Yes, the cell T13010 contains the formula =SUMIF(D12488:D13009,""&X1,T12488:T13009). When the ranges in D12488:D13009 and T12488:T13009 contain blanks, T13010 turns to #REF! error. I want it to display as a zero instead of #REF!. I also want to apply this same solution to the rest of the column T:T.

I noticed that I ran ActiveSheet.Columns("B:B").SpecialCells(xlCellTypeBlanks).EntireRow.Delete in a macro and this causes the #REF! to appear. The report cannot have blank rows so it is referring to a cell that was empty and deleted. I only want to have the #REF! to be replaced with a zero.

Thanks!! It works!

Marking this as SOLVED.