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.

	A	B	C	D
1	1:05:00	NULL	0:20:00	#VALUE !
2	0:20:00	0:30:00	1:00:00	1:30:00
3	NULL	1:00:00	0:20:00	#VALUE !
4	0:20:00	0:20:00	NULL	#VALUE !
5	0:10:00	0:20:00	0:30:00	1:00:00

<tbody>
</tbody>

Thanks,

 

[pgc01]

Hi

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

 

[footoo]

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

 

[Laurence D]

Thanks that works perfectly!