Here is a formula that adds the last 6 items in a column A

=SUM(OFFSET(A1,COUNTA(A:A)-6,,6))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Barney" wrote in message
...
How can a formula consider and act on the last 6 items in a column where a
new item is added to the next blank cell each day. I want to keep all the
old records.

Using Win XP and Excel 2002.

Thanks in advance.

Barney