Suming a certain number of rows with VLOOKUP

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.
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
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
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,999
Members
448,541
Latest member
iparraguirre89

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top