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
but that seems to get messed up even when i click and drag. any advice would
be appreciated. thanks.