Running total of budget

  • Thread starter Thread starter assistance
  • Start date Start date
A

assistance

Hi,

Some help greatly appreciated.

For my work, I am currently managing a budget of £60,000. I want t
have the budget total at the top of the spreadsheet and then a 'table
under that where I can enter description and price information o
things that the budget is spent on, and I then need the costs I ente
to be deducted from the budget at the top so I have a running total o
the budget (telling me how much I've got left to spend)

I'm sure it's very simple! All help appreciated greatly :)
 
First you need to draw a total of all of your expenditures e.g.
=SUM(B2:B100). Place this formula in a cell of your choice (B1?)

Assuming your starting Balance is in A1, enter this formula there
instead:

=60000-B1 (format as currency)

Now, as you enter amounts in B2:B100, A1 will reflect these amounts as
deductions from your starting amount.

There are lots of other ways to set this up, but this is a simple,
straightforward way (IMHO).

HTH

Bruce
 
USE A DATABASE FOR DATA AND A SPREADSHEET TO WIPE YOUR ASS WITH

Excel doesn't have data entry mechanisms.. multiple people can't enter
the same numbers in the same spreadsheet at the same time.

if you were serious about AUTOMATING your workload; you would use
Access and not Excel
 
USE A DATABASE FOR DATA AND A SPREADSHEET TO WIPE YOUR ASS WITH

Excel doesn't have data entry mechanisms.. multiple people can't enter
the same numbers in the same spreadsheet at the same time.

if you were serious about AUTOMATING your workload; you would use
Access and not Excel
 
Aaron... why would you be so rude? Does it harm you in ANY way that the
poster of this question uses Excel? If not, and unless you are
specifically asked for your Access knowledge, please stay out of this
thread. You certainly are not helping anyone with your profanity. Oh,
and did you offer instructions to the OP as to how to set up a database
to handle a few simple subtractions from a beginning number? No, I
have never seen a post from you that has helped anyone in these
newsgroups.

Thank you for understanding.

Bruce
 
Thanks to Bruce for his help - this sorted out what I wanted to do :)


As for Aaron - you're clearly a waste of space who knows nothing on
Excel.
 
USE A DATABASE FOR DATA AND A SPREADSHEET TO WIPE YOUR ___ WITH

Excel doesn't have data entry mechanisms.. multiple people can't enter
the same numbers in the same spreadsheet at the same time.

if you were serious about AUTOMATING your workload; you would use
Access and not Excel
Click to expand...


Know any good ACCESS websites like this forum??
 
you can check out the MS Access Discusson group home at:

http://tinyurl.com/dakf8

Hopefully, there won't be an "Aaron" types hanging around there
trashing Access saying Excel is the ONLY way to do things....

Good Luck

Bruce
 
Back
Top