Solved: Blank cells

[RonNCmale]

I have the attached excel sheet that works great with the exception I wish the cells under count to be blank until number code is entered. Any way to accomplish this? The count in red is repeated to the last cell.

[MaximS]

try that in column H5 and copy down:

=IF(OR(H4="",E5=""),"",SUM(H4,G5))

[georgiboy]

For range "H5" and drag down...

=IF(E5<>"",SUM(H4,G5),"")

Hope this helps

[RonNCmale]

:friends: Thanks codes works well.