# Suming a certain number of rows with VLOOKUP

#### txgodfather

##### New Member
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.

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

##### Well-known Member
Excel Workbook
ABCDEF
1DateCostBillDateWeekly Sum
21-Mar-0981gas7-Mar-09201
32-Mar-0967entertainment
43-Mar-09100entertainment
54-Mar-0996gas
65-Mar-0944gas
76-Mar-0964rent
87-Mar-0917rent
98-Mar-091food
109-Mar-0955gas
1110-Mar-093entertainment
1211-Mar-0992gas
1312-Mar-0926food
1413-Mar-097rent
1514-Mar-0926entertainment
1615-Mar-0933rent
1716-Mar-096gas
1817-Mar-0957gas
1918-Mar-0938entertainment
2019-Mar-0985rent
2120-Mar-0910entertainment
Sheet1

Replies
1
Views
574
Replies
3
Views
144
Replies
3
Views
347
Replies
3
Views
344
Replies
0
Views
758

1,191,131
Messages
5,984,846
Members
439,919
Latest member
ketsueki82

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back