To find the cumilative balance

[pol]

Hi all,

Please forgive me the same question is posting again. I have the following
excel . I want to get a cumilative balance as follows.
A B C D E(Cum.bal)
1 10
2 -3.5
3 -1.5
4 -3 -2 0.00
5 20
6
7 -10
8 -10 0.00

Please help to get the balance n column E. The balance have to findout
just before the blank column end in A range.

Please help
With thanks and regards
Pol

 

[Daryl S]

Pol -

You can do this with two columns (and you can hide the first one). This
assumes there is no extraneous text (like spaces) in the data - they are all
numeric). The only issue is the last group of cells - the final balance will
not show unless there is a 'dummy' value in column A in the cell below the
last range (where the next group would start). This 'dummy' value can be a
space so no one sees it.

Assuming you have headers in row 1, and data starts in cell A2, put this in
cell F2:
=IF(ISBLANK(A2),F1+SUM(B22),SUM(A22))
Then put this in cell G2:
=IF(ISBLANK(A3),"",F2)

Drag these down the columns. You can hide column F and column G will have
what you want.