[lampshade]

i would like to make a simple set up of credits and debits. basically what is in
column E will always be subtracted from G, and what is in F will always be added
to G. and G will be the running balance. i tried using the basic sum function

=SUM(G4,-E5,F5)

but that seems to get messed up even when i click and drag. any advice would
be appreciated. thanks.

[Advertisements]

Try using this formula in whatever cell you want your bablance to be in
=SUM($E$2:$E$65000)-sum($F$2:$F$65000)







or if you want a running balance
entered in cell g2 and copied down the spreadsheet
formula is writen to adjust the range as it is copied down.
=SUM(E$2:E2)-SUM(F$2:F2)

I have one more way to do this if this isn't what you want.

Edited by jasonharrod, 14 July 2005 - 09:05 PM.

[jasonharrod]

Try using this formula in whatever cell you want your bablance to be in
=SUM($E$2:$E$65000)-sum($F$2:$F$65000)







or if you want a running balance
entered in cell g2 and copied down the spreadsheet
formula is writen to adjust the range as it is copied down.
=SUM(E$2:E2)-SUM(F$2:F2)

I have one more way to do this if this isn't what you want.

Edited by jasonharrod, 14 July 2005 - 09:05 PM.