Consider last 6 cells only
Sorry but this isn't working for me. I always get 'zero'.
I have 1, 2, 3, 4, 5, 6, 7, and 8 in A1 thru A8. A20 should give me the sum
33 for A3:A8. When I add 9 in A9, the sum in A20 should be 39.
Thanks, Barney
"Bob Phillips" wrote in message
...
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
|