Holiday Pay

  • Thread starter Thread starter johnrann
  • Start date Start date
J

johnrann

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.
 
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.
 
Assuming the data is in A1:A100, use

=SUMPRODUCT(--(LARGE(A1:A100,ROW(INDIRECT("1:12")))))
 
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
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
=SUM(OFFSET(A1,0,0,12,1))/12

or simply:

=AVERAGE(OFFSET(A1,0,0,12,1))

--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
Sandy Mann said:
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
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk


message news:[email protected]...
Click to expand...
 
Back
Top