If your dates start in A2, and the numbers to be added in B2, put this formula in C2 and fill down and see if it works:

=IF(B2="x",0,C1+B2)

C1 should be blank

- Moo