Formulaes
 

Ok, I am trying to do a budget on through a calendar format, what I want to
know is how can I add the numbers up for the week.

basically if this is my calendar

Monday: rent $200, electricity $50
Tuesday: Kids $20
Wednesday: nothing
Thursday: credit card $100
Friday: nothing
Saturday: Food $50

So picture that in a table form, where the days of the week or the headings
of the columns and then there are 30/31 days as in a calender. However, at
the beginning of each week, I want to be able to glance at a figure to see
what I need in my bank account.

so, just next to the week, I would like a formula that adds up the figures
automatically, so if my rent changes, I can change it on the calendar and it
will automatically update the amount I need in the account.

So ideally, what I am looking for is something similar to
=sum(a1,b1,c1,d1,e1,f1,g1) in order to add the figures up....

so a1 = Monday, b1= Tuesday etc etc

however because I get paid on Wednesday, I have to make sure I have enough
money from Thursday to Wednesday.....
I would gladly upload a template of mine, but I don't know if you can...

Any help, or if you need more clarification, please let me know.

Many many thanks

Formulaes
 

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Shaz" wrote in message
...
Ok, I am trying to do a budget on through a calendar format, what I want
to
know is how can I add the numbers up for the week.

basically if this is my calendar

Monday: rent $200, electricity $50
Tuesday: Kids $20
Wednesday: nothing
Thursday: credit card $100
Friday: nothing
Saturday: Food $50

So picture that in a table form, where the days of the week or the
headings
of the columns and then there are 30/31 days as in a calender. However,
at
the beginning of each week, I want to be able to glance at a figure to see
what I need in my bank account.

so, just next to the week, I would like a formula that adds up the figures
automatically, so if my rent changes, I can change it on the calendar and
it
will automatically update the amount I need in the account.

So ideally, what I am looking for is something similar to
=sum(a1,b1,c1,d1,e1,f1,g1) in order to add the figures up....

so a1 = Monday, b1= Tuesday etc etc

however because I get paid on Wednesday, I have to make sure I have enough
money from Thursday to Wednesday.....
I would gladly upload a template of mine, but I don't know if you can...

Any help, or if you need more clarification, please let me know.

Many many thanks