having a brain cramp...

[tjm502]

so, I am trying to make a simple formula from returning a 0 and want it just to be blank.. I am not working the if iserror very well.. formula is =sum('Week 1'!D31:H31) I am tired of looking at the zeros and just want it to be blank if there is answer to the formula is 0.

if(iserror(sum('Week 1'!D31:H31))," ",sum(('Week 1'!D31:H31)) is not returning the correct info.

 

[MrKowz]

A sum returning 0 is not an error, so ISERROR will always return false. Instead, test for if SUM is actually 0:
=IF(SUM('Week 1'!D31:H31)=0,"",SUM('Week 1'!D31:H31))

Or slightly shorter:
=IF(SUM('Week 1'!D31:H31),"",SUM('Week 1'!D31:H31))

 

[VoG]

Try

=if(sum('Week 1'!D31:H31)=0," ",sum('Week 1'!D31:H31))

 

[tjm502]

Thank you! I knew I was making a mistake somewhere!!