1 more, lol. I have a running total column. I want it to be blank if the last line it added was blank or 0. On the first line it is only taking the figure from D12
=IF(D12>0,D12,"") and it works. it will show what is in D12 or it will be blank. But in the next box it will be what is in D12 + what is in D13 but if nothin is in D13 I want the cell blank (if its just going ot be D12's value again).
=IF(D13>0,D12+D13,"") gets an error.
If you have time here is a link to the file
http://www.naughty-coco.com/dan.xls
Thanks