I have a column of 120 numbers

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

 

[Don Guillett Excel MVP]

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.

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

 

[Rookieatit]

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

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