Still getting a #DIV/0! error?

[Allen_Mead]

ok, so I have the following formula which should leave a blank cell

=IF(SUM(T11/$T$48)=0,"",(SUM(T11/$T$48)))

Problem is, cell on row T (not T48) is empty so I get the divide by 0 error. Frustrating!

Any help would be much appreciated. Thank you.

Correction, I get a #Value! error not a div/0 error. Still the same cell, in this instance cell T11 is blank

 

[joeu2004]

First, the use of SUM in this context is redundant and not useful.

Either of the following should avoid the #DIV/0 error:

=IF($T$48=0, "", T11/$T$48)
or
=IF(N($T$48)=0, "", T11/$T$48)
or
=IFERROR(T11,$T$48, "")

The latter two work when T48 appears blank, but it is actually the null string.

(But if T48 were the null string, the error would be #VALUE, not #DIV/0. Just covering all bases.)