I have a column of 120 numbers

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

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))
 
R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top