Make sure the first line is empty
I assume that with "a space" you mean an empty row.
If your data is in Column A (starting in a2), put this formula in B2:
=IF(A2="",0,B1+A2)
And copy down as far as you need
You can format the zeros to show as spaces if that is important.

Signature
Kind regards,
Niek Otten
Microsoft MVP - Excel
| Hi,
|
[quoted text clipped - 27 lines]
|
| The formula looks complicated. Thanks for any help.
Mr. Barnes - 05 Nov 2006 03:32 GMT
>Make sure the first line is empty
>I assume that with "a space" you mean an empty row.
[quoted text clipped - 36 lines]
>|
>| The formula looks complicated. Thanks for any help.
Hey, thanks for that. Would this work as well:
=IF(A2="","",B1+A2)