Allen_Mead
New Member
- Joined
- May 31, 2019
- Messages
- 34
- Office Version
- 365
- Platform
- Windows
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
<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!
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!