Ignoring text in multicolumn calculations

[Laurence D]

Hi all,

I am trying to do an addition of three columns together of various times to get a total time. However many rows have a NULL in them when a time was not taken. I want to ignore this text to avoid getting the #VALUE ! sign which I am currently getting. Can anybody please help me with formula to ignore text in this calculation? I assume it can be done using the IFERRROR function but I have not worked out how to do this yet.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]1:05:00[/TD]
[TD="align: center"]NULL[/TD]
[TD="align: center"]0:20:00[/TD]
[TD="align: center"]#VALUE ![/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]0:20:00[/TD]
[TD="align: center"]0:30:00[/TD]
[TD="align: center"]1:00:00[/TD]
[TD="align: center"]1:30:00[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]NULL[/TD]
[TD="align: center"]1:00:00[/TD]
[TD="align: center"]0:20:00[/TD]
[TD="align: center"]#VALUE ![/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]0:20:00[/TD]
[TD="align: center"]0:20:00[/TD]
[TD="align: center"]NULL[/TD]
[TD="align: center"]#VALUE ![/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]0:10:00[/TD]
[TD="align: center"]0:20:00[/TD]
[TD="align: center"]0:30:00[/TD]
[TD="align: center"]1:00:00[/TD]
[/TR]
</tbody>[/TABLE]


Thanks,

 

[pgc01]

Hi

What is your formula? Sum() should ignore the text values.

 

[footoo]

=SUMIF(A1:C1,"<>#Null!")

 

[Laurence D]

Thanks that works perfectly!