having a brain cramp...

tjm502

New Member
Joined
Mar 4, 2009
Messages
4
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.
 

Some videos you may like

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
Joined
Jun 30, 2008
Messages
6,653
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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
Joined
Jun 19, 2002
Messages
63,650
Try

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

Watch MrExcel Video

Forum statistics

Threads
1,108,989
Messages
5,526,095
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top