Help with Average Formula

  • Thread starter Thread starter Please help
  • Start date Start date
P

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?
 
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)
 
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)
 
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.
 
thanks a lot but I found the right formula is =(SUMIF(A2:A900,">" &
H3-365,B2:B900)/365)
 
Back
Top