Finding average of last 10

freeman77 · #1 (**permalink**) 05-05-10, 15:06

Hi,
I need help.

I am working in excel and trying to write a formula that will calculate the average of the last ten numbers. I want to refresh my data and the formula with always find the last ten.

I have three columns:

column 1 - date
column 2 - mill
column 3 - levels

I have 703 rows. I wanna focus on column 3

Thanks

sco08y · #2 (**permalink**) 05-12-10, 09:44

Don't have Excel handy, but I think this should work:

Code:

=AVERAGE(INDIRECT("C" & ROWS() - 9 & ":C" & ROWS()))

Colin Legg · #3 (**permalink**) 05-12-10, 15:47

For reference, this is a duplicate thread of the one in the Excel board:
Excel formula. finding the last 10

Internet Services

Web Development

Digital Marketing

Consumer Tech