**Associate**

I need some help in working out a column of numbers which I'm adding up a cumulative total... so let's say the column has 30 expected values and I only have the 3rd so far e.g. 3000, 3000 and 4000. This is displayed as, which I have done already:

3000

6000

10000

I need to display in a cell the latest cumulative total spend rather than manually entering the last number. Is this possible?

I'm looking at ISBLANK formula or similar as I know there are dashes displayed if no numbers. Working in some sort of if loop statement looking down the column. Perhaps check if cell is 0 then look at the previous number if above 0 then display. Something along those lines. All help is appreciated. Thanks.