Simple IFERROR to return a blank Cell and not a 0

[Allen_Mead]

Hi,

I've trawled through the forum to see if I can find an answer on this but most apply to VLOOKUP which is not appropriate in my case.

I have the following table where I want to add up the number of hours spent on each task, but, if there are no hours, I don't want a 0 in the total column

[TABLE="width: 500"]
<tbody>[TR]
[TD]Task[/TD]
[TD]Mon[/TD]
[TD]Tues[/TD]
[TD]Wed[/TD]
[TD]Thurs[/TD]
[TD]Fri[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Fred[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I have to following formula in the total column

=IFERROR(SUM(D7:H7),"")

Which works just fine but leaves a 0 which to my mind shouldn't

Some help would be much appreciated!

 

[Fluff]

Hi & welcome To MrExcel.
How about
=IF(SUM(D7:H7)=0,"",SUM(D7:H7))

Alternatively just hide the 0 values

 

[Allen_Mead]

Hi & welcome To MrExcel.
How about
=IF(SUM(D7:H7)=0,"",SUM(D7:H7))

Alternatively just hide the 0 values

Hi and thanks for the welcome!

Genius! works perfectly!

 

[Fluff]

You're welcome & thanks for the feedback

 

[Gerald Higgins]

Another solution would just be to apply a custom format that does not display zero values.