Zero vs Empty

[ConnieIrene]

I am trying to Total 2 cells that will have FUTURE data containing conditional formatting; however, while my data sheet is blank, I want my sum total to be blank also (not zero). A Sum value of 0 activates Red Fill conditional formatting, so the Sum cell shows 0 (Red) rather than " " (White).

In other words, I want "Blank Cell A" + "Blank Cell B" to= "Blank Cell C" until A or B contains data.

I was able to format my blank cells individually, but can't seem to format this Sum column. Any ideas?

PRINT SCREEN HELP.jpg

[benishiryo]

hi ConnieIrene, welcome to the forum. try this in C:
=IF(COUNT(A1:B1),A1+B1,"")

not sure about the formatting of blank cells. uploading a sample Excel file in the thread will enable us to help you better. to upload, press "Go Advanced" beside the "Post Quick Reply" button & click on the paperclip icon

[Ace_XL]

IN Cell C use

Please Login or Register  to view this content.

[Elasar]

can this formula help?

=if(or(a1<>0,b1<>0),a1+b1,"")

this will show a number if a1 or b1 is different than zero, but if you want it works only both a1 and b1 have values, then replace OR in the formula with AND

[ConnieIrene]

=IF(AND(A1="",B1=""),"",SUM(A1:B1)) worked!

YAY! THANK YOU SO MUCH! I'm completely self-taught with excel, and I knew I had hit a brick wall with this one. Y'all are the best!
If you ever have a question about your child's reading skills.... haha.