Thread
:
Holiday Pay
View Single Post
#
4
Sandy Mann
Posts: n/a
John,
To get the average - rather than the SUM - then with your data starting in
A1, in row 12, (any column), try:
=SUM(OFFSET(A1,0,0,12,1))/12
and copy down the column
--
HTH
Sandy
Replace@mailinator with @tiscali.co.uk
"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
Reply With Quote