Holiday Pay

[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.

 

[Barb Reinhardt]

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.

 

[Bob Phillips]

Assuming the data is in A1:A100, use

=SUMPRODUCT(--(LARGE(A1:A100,ROW(INDIRECT("1:12")))))

 

[Sandy Mann]

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

 

[Sandy Mann]

=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

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]...

 

[Bob Phillips]

Avearge, divide by

MAX(12,COUNTA(A:A))

--
HTH

Bob Phillips

Assuming the data is in A1:A100, use

=SUMPRODUCT(--(LARGE(A1:A100,ROW(INDIRECT("1:12")))))

--
HTH

Bob Phillips

message news:[email protected]...