formula help

S

Shaz

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.
 
J

JLatham

Hmmmm, no takers in 8 hours. Ok, I'll bite. Send the worksheet as an
attachment to an email to (remove spaces)
HelpFrom @ JLatham Site.com
and include the description of your request in the email, and a link to your
post here wouldn't hurt as a reminder, along with mentioning that you are
"Shaz" on this board. That should jog my memory. I'll see what I can do for
you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulaes 1
Need some PWA help 0
Average of last 30 days 9
Shift Schedule Formula 1
Cumulative Timesheet Entries 5
Drop Down List Question 3
Easy question (just not for me) 2
CALENDAR CREATION 1

Top