Help with Average Formula

[Please help]

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?

 

[Sheeloo]

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]

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)

 

[Luke M]

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.

 

[Please help]

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