Excel Masters Come Forth.....

Ok, so Im familiar with excel, and Im decent with formulas, but now I am stepping into areas a little beyond what I know. I am creating a personal budget excel spreadsheet. Ill list off the best I can what I am trying to do.....

Sheet 1 (main)
A2 = "Mortgage"
B2 = Payment Amount (Range = Mortgage_Payment)
D2 = Sept
E2 = Oct
F2 = Nov
...etc...
Row 3 = Insurance
Row 4 = Car Payment
...etc...

Sheet 2 (weekly)
Column D = 9/5/10
D6 = Mortgage Amount Paid
Column E = 9/12/10
E6 = Mortgage Amount Paid
Column F = 9/19/10
F6 = Mortgage Amount Paid

Row 7 = Insurance
Row 8 = Car Payment
...etc...

Row 21 = Total Expenses


-------------------------------

I want to be able use payment amount from sheet 1 as a reference to apply to sheet 2. When you input payment amount per week on sheet 2 it will sum up totals of weeks within a month and give either difference to be paid (forwarded to sheet 1 in corresponding month and billing company) or mark as Paid.

I have played around some with SUMIF(S), IF, COUNTIF(S), and a few others.

Overall goal here is I want to have one sheet I can put bill min amount due, which most stay the same except for the obvious like power, and for that reason is why I wanted the separate sheet for the input.
Another sheet for inputing actual payment amounts logging payment date and amount. Then on either sheet or a new one, have a over view of payments totaling monthly, showing if payment has been satisfied or remainder amount to satisfy payment amount.

So there ya have it. Let me know if there is anyone out there who can help.....

((I know there are programs out there that will do this, but I want to do this in excel, I have a method to my madness))

 

www.mint.com

 

Thanks, Ill check it out, but still doesnt answer my question.....