Hi,

I had a similar question yesterday, related to a table of data that gets
updated daily. The top row is this month's date, and the row below is the
bank balance for that particular day. Then, the final column (to the right)
is for totals. See below:


Daily Total
Dates| 7/1 7/2 7/3 etc.
Value| $1 $4 $5 etc. ?


Can someone help me create a formula that will add up the most recent seven
days worth of bank balances? For example, after I input today's (7/24)
balance I will want the formula to automatically sum July 18th - July 24th's
balances.

Thanks in advance for your help!