cumulative summing

[nelg001]

Hi All,

I'd really appreciate some help with a problem that I just cannot solve

example

Col........A......B......C......D......E......F......G......H......I......J......K
Row1......2......6......4......2......4......3......0......0......5.....This row has random numbers
Row2......2.....8......12.....14....18.....21..#N/A..#N/A..??(26)...This row sums previous number (Row2)+number above (Row1)=cumulative total

problem... being what formula can I put in the ?? column to pick up the cumulative count?...

When there is nothing to add to the cumulative total, I am telling Row2 to = #N/A because I need to chart Row2 and I don't want to chart 0's or repeat numbers

....can anyone please offer a non-VB solution to 'picking-up' where the count was lost...?

Many thanks in advance

nelg