Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

basic excel help needed


  • Please log in to reply

#1
lampshade

lampshade

    New Member

  • Member
  • Pip
  • 9 posts
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.
  • 0

Advertisements


#2
jasonharrod

jasonharrod

    Member

  • Member
  • PipPip
  • 18 posts
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.

  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP