Excel: Average of daily values incrementing by each day

Factual Questions
1

I have a question about Excel formulas for which I would greatly appreciate some advice or assistance.
I have a column in which I populate a daily value (let’s say “Points”) in each row. So, for example, cell A1 has the points for Monday 15 Feb, A2 has the points for Tuesday 16 Feb and so on.
I am trying to create a formula that will, in B2, give me the average of A1 and A2; and in B3 give me the average of A1 to A3, with the average of the A cells always starting at A1 and including the current (eg today’s) A cell. So the total A values being averages always increment by one day.

Any help would be greatly appreciated, thanks

2

=AVERAGE(A$1:A2)

If you put that formula in cell B2, then you drag it down in column B and it will always give you the average starting with A1 and down to the current row.

3

=average($A$1:A2)

ETA: Ninja’d, and with a slightly better formula!

4

@Clawdio and @RitterSport, thank you so much for that.

5

Sure. The dollar sign says “don’t change this value as you copy this formula around.” That is, it’s a fixed location, rather than a relative location.

So, when you drag down the formula, Excel knows to keep the 1 the same in A$1, but looks at A2 as a relative location, so it will get updated as you copy the formula.