Return blank if 3 cells = 0, otherwise sum cells that are not blank

[Heaney]

Good afternoon!

I have a sheet where I'm trying to calculate turn around time.

Colum I = "Completion Time A", with the following formula in I6: =IF(OR(C6="",B6=""),"",C6-B6)
Column J = "Completion Time B", with the following formula in J6: =IF(OR(E6="",D6=""),"",E6-D6)
Column K = "Completion Time C", with the following formula in K6: =IF(OR(G6="",F6=""),"",G6-F6)

Column L = TAT

What I would like to do is have column L return a blank value if cells I6:K6 are all blank. If any of the cells has a value I would like to SUM I6:K6. I'm struggling to come up with a formula that works.

Thank you in advance!

 

[offthelip]

try this

=If(AND(I6="",J6="",K6=""),"",Sum(I6:K6))

 

[Heaney]

try this

=If(AND(I6="",J6="",K6=""),"",Sum(I6:K6))

This worked like a charm. Thank you for the quick response!