Avearge, divide by

MAX(12,COUNTA(A:A))

--
HTH

Bob Phillips

"Bob Phillips" <phillips@tiscali.co.uk> wrote in message
news:unMg6EsiFHA.1948@TK2MSFTNGP12.phx.gbl...
> Assuming the data is in A1:A100, use
>
> =SUMPRODUCT(--(LARGE(A1:A100,ROW(INDIRECT("1:12")))))
>
> --
> HTH
>
> Bob Phillips
>
> "johnrann" <johnrann.1say2b_1121583928.3138@excelforum-nospam.com> wrote
in
> message news:johnrann.1say2b_1121583928.3138@excelforum-nospam.com...
> >
> > How do I set up a spreadsheet to get an average of the last 12 weeks
> > pay. This is obviously a rolling figure changing from week to week.
> >
> >
> > --
> > johnrann
> > ------------------------------------------------------------------------
> > johnrann's Profile:
> http://www.excelforum.com/member.php...o&userid=25295
> > View this thread:
http://www.excelforum.com/showthread...hreadid=387815
> >
>
>