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
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