Three conditional if statements in same cell

[techgirl]

I have three conditions in one cell...

Cells C3, D3, E3, can have blanks, zeros or numbers.

Here is the conditions...
Sum(C3:E3) are all blanks, leave cell empty
Sum(C3:E3) >0 = return sum
Sum(C3:E3) =0 = return a zero

How would I write that in a single formula?

 

[Special-K99]

=if(counta(c3:e3)=0,"",sum(c3:e3))

 

[GR00007]

=if(len(c3&d3&e3)=0,"",sum(c3:e3))

 

[Fluff]

Or
=IF(C3&D3&E3="","",SUM(C3:E3))

 

[techgirl]

Thank you that worked, except for the formatting color of clear(no formatting. If there was previously a value in the cells, then I go back and make all three null, no values, no characters, it turns yellow., even though all three cells are blank. I don't know how to make the cell go back to no formatting if the value is blank.

 

[Fluff]

Do you have Conditional formatting applied to the cell?

 

[techgirl]

Yes. The cells that are just values and not a formula, the conditional formatting works. Its just the columns that are doing the sum, that doesn't work for blanks. Yellow works when there is a number, green works when there is a zero, but when the cells are blank, it keeps the yello; it never goes back to clear.

Conditional formatting rules...
Green; =AND(C3=0,C3<>"")
Yellow; Cell value greater than 0
No formatting; =isblank($c$3:$W$6)

 

[Fluff]

Change you yellow format to a formula
=AND(E3>0,E3<>"")

There should be no need to set a format for no formatting as that is the default

 

[techgirl]

OMGoodness, it was that easy. Thank you so much; everyone was wonderful in helping me!!

 

[Fluff]

Glad we could help & thanks for the feedback