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.
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.
try that in column H5 and copy down:
=IF(OR(H4="",E5=""),"",SUM(H4,G5))
Thanks codes works well.