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

Task	Mon	Tues	Wed	Thurs	Fri	Total
Bob	1	1	3			4
Fred

<tbody>
</tbody>

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.