Very simple Averages question

[aldino]

Hi basically i have a list of salaries. Now i need to get the average of salaries up to the year when it is requested.

EG.
£10
£12
Average = £11

Now i know to do average, its =AVERAGE(cell:cell) so it would be =AVERAGE(A2:A3)

BUT when i add another one in, i want it to then do =AVERAGE(A2:A4) but it just does A3:A4

Basically how can i get it to keep its A2 for them all, and just do the average up to the line required?

Thanks

 

[Fat Cat]

Easy way is to make the end cell of your formula way beyond your data
(assuming you don't have anything else underneath)

eg:

=AVERAGE(A2:A65536)

will average any numbers it finds in column A from row 2 down

 

[aldino]

hi thanks, but i do have something below

its

£20,000.00
£20,600.00
£21,218.00
£21,854.54
£22,510.18
£23,185.48

so for each row, i want to know the average salary

eg for the 2nd one its A1:A2, how can i get the 3rd to be A1:A3, not A2:A3 which is what happens when i drag the formula down to the rest of them

 

[Fat Cat]

in your formula in the first cell, put a $ symbol infront of the A and the 1
but not in front of the second cell address

eg:

=AVERAGE($A$1:A2)

now drag the formula down and A1 will always stay as A1

 

[aldino]

Thanks - exactly what i needed