I have two years data in one excel spread sheet, I need to pull rollover
average for 365 days (from today until 1 year earlier exp 27-Apr-09 through
26-Apr-2008)

Can anyone help me please?

Assuming your last row is 702 (assuming headers in row 1) with dates in Col A
and Value to average in Col B, enter this in C720
=Average(C338:C702)
You can copy this formula UP till row 366 or till you get a #REF error (when
you run out of 365 cells to average)

"Please help" wrote:


I have two years data in one excel spread sheet, I need to pull rollover
average for 365 days (from today until 1 year earlier exp 27-Apr-09 through
26-Apr-2008)

Can anyone help me please?

Well I need the roll over daily 365 days average (as I add data on tomorrows
report it should automaticly skip date tu current 365)

"Sheeloo" wrote:

Assuming your last row is 702 (assuming headers in row 1) with dates in Col A
and Value to average in Col B, enter this in C720
=Average(C338:C702)
You can copy this formula UP till row 366 or till you get a #REF error (when
you run out of 365 cells to average)

"Please help" wrote:


I have two years data in one excel spread sheet, I need to pull rollover
average for 365 days (from today until 1 year earlier exp 27-Apr-09 through
26-Apr-2008)

Can anyone help me please?

Could do something like:

=AVERAGE(OFFSET($A$1,COUNTA(A:A)-1,0,-365,1))

Note that I'm assuming you already have at least 365 points of data, or this
formula will return an error.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Please help" wrote:

Well I need the roll over daily 365 days average (as I add data on tomorrows
report it should automaticly skip date tu current 365)

"Sheeloo" wrote:

Assuming your last row is 702 (assuming headers in row 1) with dates in Col A
and Value to average in Col B, enter this in C720
=Average(C338:C702)
You can copy this formula UP till row 366 or till you get a #REF error (when
you run out of 365 cells to average)

"Please help" wrote:


I have two years data in one excel spread sheet, I need to pull rollover
average for 365 days (from today until 1 year earlier exp 27-Apr-09 through
26-Apr-2008)

Can anyone help me please?

thanks a lot but I found the right formula is =(SUMIF(A2:A900,"" &
H3-365,B2:B900)/365)

"Luke M" wrote:

Could do something like:

=AVERAGE(OFFSET($A$1,COUNTA(A:A)-1,0,-365,1))

Note that I'm assuming you already have at least 365 points of data, or this
formula will return an error.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Please help" wrote:

Well I need the roll over daily 365 days average (as I add data on tomorrows
report it should automaticly skip date tu current 365)

"Sheeloo" wrote:

Assuming your last row is 702 (assuming headers in row 1) with dates in Col A
and Value to average in Col B, enter this in C720
=Average(C338:C702)
You can copy this formula UP till row 366 or till you get a #REF error (when
you run out of 365 cells to average)

"Please help" wrote:


I have two years data in one excel spread sheet, I need to pull rollover
average for 365 days (from today until 1 year earlier exp 27-Apr-09 through
26-Apr-2008)

Can anyone help me please?