Carry Over Total Problem

Hi,

I'm having a problem with the below pictured table and its formula and I hope someone could help me! I find this hard to explain, so please bear with me.

http://i101.photobucket.com/albums/m..._ExcelHelp.jpg


This report is for every day of the month incl weekends. However, for this particular section, there are no deliveries on a Sunday, so column A will consist of a 0 at some point.

If I receive 5 crates on Saturday and open 1 I have 4 left on Sunday.

I receive 0 crates on Sunday so I still have 4 to open on Monday along with whatever else arrives.

With the formula i have in place currently , empty cells for the rest of the month return 0 instead of the last total, which is what I require, however, it also fails to add the remainder to the next day if I recieve nothing in-between deliveries.

Any help appreciated and I hope that makes sense...

please post as an excel file, your picture is small, and not really very helpful