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
>