An OFFSET question

[johnb]

OFFSET's 1st argument is Reference my q is how do I get
reference to increment. To put it another way. Say I have
12 months data. Next month I add that month in so I now
have 13 months data, but how do get OFFSET to drop the
1st month so that I only view the last 12 months?

TIA
johnb

 

[Frank Kabel]

Hi
maybe something like
´SUM(OFFSET($A$1,COUNTA(A:A)-1,-12,1))

 

[Bob Phillips]

Hi John,

How about

=SUM(OFFSET(N1,0,-12,1,12))

--

HTH

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