An OFFSET question
 

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"johnb" schrieb im Newsbeitrag
...
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

Hi John,

How about

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

--

HTH

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


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