I have a column of 120 numbers

  • Thread starter Thread starter Skip
  • Start date Start date
S

Skip

to the left the date is entered. I want to get the average of the
last 30 numbers, the last 60 numbers and the last 90 numbers, and
the entire column of 120. I can get the 120 average, but the other
formulas
give me the date as my average. Any help appreciated.
 
to the left the date is entered.  I want to get the average of the
last 30 numbers, the last 60 numbers and the last 90 numbers, and
the entire column of 120.  I can get the 120 average, but the other
formulas
give me the date as my average.  Any help appreciated.
Click to expand...

You really haven't explained very well. This does the last 10
=AVERAGE(OFFSET(B2,MATCH(9999,B:B)-11,0,11,1))
 
You really haven't explained very well. This does the last 10
=AVERAGE(OFFSET(B2,MATCH(9999,B:B)-11,0,11,1))
Click to expand...

how is your cell formatted. ensure you have a number, text or general
and not date for the cell.
 
Back
Top