txgodfather
New Member
- Joined
- Mar 12, 2009
- Messages
- 4
I am trying to create a cash flow forecasting model in Excel 2007. I have a list of my reoccurring bills with the day they are due, amount due, and a description. For example:
1 500.00 rent
2 100.00 gas
3 700.00 electric
I am wanting to sum up a week's worth of payments so that I can see my cash output each week. So far I have been able to extract the day of the month from a date and then use that day in a VLOOKUP and get the corresponding dollar amount I owe. Now what I want to do is tell the formula to give me the sum of the next seven rows. At this point I am stuck, any help would be greatly appreciated.
1 500.00 rent
2 100.00 gas
3 700.00 electric
I am wanting to sum up a week's worth of payments so that I can see my cash output each week. So far I have been able to extract the day of the month from a date and then use that day in a VLOOKUP and get the corresponding dollar amount I owe. Now what I want to do is tell the formula to give me the sum of the next seven rows. At this point I am stuck, any help would be greatly appreciated.