Formula

[bryan gaudette]

Hi,
I'm trying to average the last 10, in a column of numbers

the column is a4 - a84, i want to average the last 10 in that column,
and have it so it averages the last 10 as i log in to that column.

thanks for any help

Brya

 

[James Ravenswood]

=AVERAGE(OFFSET(A4,MATCH(2,1/(A4:A84<>0))-1,,-10))
This is an array formula that must be entered with CNTRL-SHFT-ENTER rather than just the ENTER key

 

[darbary]

Hi,
I'm trying to average the last 10, in a column of numbers

the column is a4 - a84, i want to average the last 10 in that column,
and have it so it averages the last 10 as i log in to that column.

thanks for any help

Bryan

i have a similar problem, did you get any simple solution?
i need to update data to column and want a formula for AVERAGE tha
averages just the last 12 data - thanks - darbar