Hello!

Am wondering if there is a quick way to average different rows. I'll try to make myself clear: I have a column (say column A) with 100 values to average.

in B1 I write: =AVERAGE(A1:A100)
in B2 I write: =AVERAGE(A2:A100)
in B3 I write: =AVERAGE(A3:A100)

... and so on till I reach =AVERAGE(A100:A100)

I tried with copy/paste, but it takes too long as I have more than 500 rows!!!!!!! Any suggestion please?

Many Thanks
pitto