# having a brain cramp...

#### tjm502

##### New Member
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.

### Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

#### MrKowz

##### Well-known Member
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

##### Legend
Try

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

#### tjm502

##### New Member
Thank you! I knew I was making a mistake somewhere!!

Replies
7
Views
82
Replies
25
Views
171
Replies
6
Views
101
Replies
2
Views
29
Replies
0
Views
44