Latest running 3 month total

[thuyle26]

Hi everyone,

It's my first time posting so I hope I am asking a not too basic
question...I tried searching for previous posting relating to this but
had no luck. My question is, I have a worksheet with months
starting in July 07 - June 08. Each month, as data become available,
a new month's of data will be added to the worksheet. If possible, I'd
like another column in my worksheet to always calculate the lastest
three months. For the first couple of months, July 07 and August 07,
as there will be less than three month's worth of data, it would only
calculate what's available or display blank. Is this possible.

I hope that makes sense. Any help would be very much appreciated!!
Thanks!!

TL

 

[Guest]

Say July 07 data is in column F, so for row 2

So in F2:
=IF(COUNTA($F$2:$R$2)<3,"",SUM(OFFSET($F2,0,COUNTA($F$2:$R$2)-3,1,3)))

You can then drag fill it down column S.

 

[Bob Phillips]

see response in public.excel

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)