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

Can anyone please help me out with making a formula


  • Please log in to reply

#1
demirkol

demirkol

    Member

  • Member
  • PipPipPip
  • 201 posts
I decided to start up a document where it shows how much money i make and spend. But I want to have a formula where it adds all of the info in column B and minus all of the info in Column C and gives me a total on the bottom.
  • 0

Advertisements


#2
piper

piper

    Retired Staff

  • Retired Staff
  • 2,459 posts
Hi demirkol.

Are you going to have a running total on each row, perhaps in column D? If so, the formula in D2 would be +D1+B2-C2. This takes the previous balance (D1), adds deposits (B2) and subtracts expenditures (C2). Then just copy that formula down.

Is that close to what you need?
  • 0

#3
demirkol

demirkol

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 201 posts
http://img296.images...untitlednq2.png

here is the image i want to takeway the purple part from the yellow and I want the total in the orange cell.


thanks in advance
  • 0

#4
piper

piper

    Retired Staff

  • Retired Staff
  • 2,459 posts
=sum(c3:c8)-sum(b3:b8) would go in D12

This sums all the figures in C (expenditures) and subtracts the sum of all figures in B (income).
  • 0

#5
demirkol

demirkol

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 201 posts
thank you so much. So if I add new numbers I just change the cell number?
  • 0

#6
demirkol

demirkol

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 201 posts
http://img296.images...untitlednq2.png

here is the image i want to takeway the purple part from the yellow and I want the total in the orange cell.


thanks in advance

Attached Files


  • 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