View Full Version : Solved: Blank cells
RonNCmale
04-20-2009, 11:57 PM
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
04-21-2009, 12:28 AM
try that in column H5 and copy down:
=IF(OR(H4="",E5=""),"",SUM(H4,G5))
georgiboy
04-21-2009, 12:29 AM
For range "H5" and drag down...
=IF(E5<>"",SUM(H4,G5),"")
Hope this helps
RonNCmale
04-21-2009, 01:32 AM
:friends: Thanks codes works well.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.