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