Say your 31 days go from B2 to AF2.

Enter this *array* formula in AG2:

=SUM(INDEX(B2:AF2,LARGE(COLUMN(A:AE)*(B2:AF2<""), 7)):AF2)

--
Array formulas are entered using CSE, <Ctrl <Shift <Enter, instead of the
regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually. Also, CSE *must* be used when
revising the formula.

Copy down as needed.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===



"Bob" wrote in message
...
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!