Averaging values in different rows

[pittopitto]

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

[daddylonglegs]

If you put this formula in B1

=AVERAGE(A1:A$100)

you can copy it down to B100 and it will automatically adjust as you want.

To "fill down" put the formula in B1 and place cursor on the bottom right corner of B1 until you see a black +, this is the "fill handle". Double click the fill handle and the formula should automatically fill down column B as far as you have values in column A

[Paul]

If you make a small change in your formula, it should work so that you can simply fill your formula down 500 rows or more..

Instead of =AVERAGE(A1:A500)

Use =AVERAGE(A1:$A$500)

Once you have entered this into B1, click on the "fill handle" in the lower right corner of the cell and drag down to row 500. Your formula will update, but the $A$500 part will not change. It will end up like:

=AVERAGE(A2:$A$500)
=AVERAGE(A3:$A$500)
=AVERAGE(A4:$A$500)...etc, down to
=AVERAGE(A500:$A$500)

[pittopitto]

Wow it worked like I wanted!!! It saves me lots of time!! Thank you so much!

So... the character $ before the column letter and/or row number simply makes these parameters fixed????

How interesting.....

Cheerio

Pitto