To find the cumilative balance

P

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
 
D

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(B2:D2),SUM(A2:D2))
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top