#REF! to Zero?

[excellenthelp]

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!!

[NBVC]

What is the logic supposed to be? Does T13010 contain the SUMIF formula?

[excellenthelp]

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.

[NBVC]

The SUMIFformula should already result in 0 if the columns are blank, unless you are referencing a sheet that is not actually there.

[excellenthelp]

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.

[NBVC]

i can probably suggest:

=IFERROR(SUMIF(D12488:D13009,""&X1,T12488:T13009),0)

[excellenthelp]

Thanks!! It works!

Marking this as SOLVED.