# Very simple Averages question

#### aldino

##### New Member
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

### Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
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

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

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

Thanks - exactly what i needed

Replies
12
Views
267
Replies
1
Views
94
Replies
0
Views
297
Replies
3
Views
145
Replies
9
Views
489

1,217,502
Messages
6,137,015
Members
450,038
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back