I assume you have observations for each week of pay. Use the SUMIF
function. I don't have time to find other links for you. I'm sure someone
else can.

"johnrann" wrote in
message ...

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