Balance Forward on Excel

[ExcelUser2011]

Hi. I need a formula to make a Balance Forward.
Let me try to explain. I want to make a ledger of open invoices by customer and to see after each line a "Balance Forward" to add up all the "G" and keep in mind that the amounts in "G" are negative amounts and if you add all the "G" it will reverse itself to a PLUS amount and I need it should add up only the previous lines from the G column and show as a total owed. (I hope this makes scense

<TABLE style="WIDTH: 640pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=852 border=0 x:str><COLGROUP><COL style="WIDTH: 101pt; mso-width-source: userset; mso-width-alt: 4900" width=134><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3730" width=102><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3766" width=103><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3913" width=107><COL style="WIDTH: 92pt; mso-width-source: userset; mso-width-alt: 4498" width=123><COL style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3254" width=89><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2816" width=77><COL style="WIDTH: 88pt; mso-width-source: userset; mso-width-alt: 4278" width=117><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 101pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=134 height=17>A1 Invoice /
B1 Date Delivered
C1 Status
D1 Invoice Amount
E1 Delivered Amount
F1 Paid
G1 Balance
H1 Balance Forward

</TD><TD class=xl23 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 77pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=102>
</TD><TD class=xl22 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 77pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=103></TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 80pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=107></TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 92pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=123></TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 67pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=89></TD><TD class=xl26 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 58pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=77></TD><TD class=xl25 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 88pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=117></TD></TR></TBODY></TABLE>
CHEERS!

 

[Andrew Poulsom]

Is it in H2 copied down?

=-SUM(G$2:G2)

 

[ExcelUser2011]

Yes sir.
Thanks!