Rolling 12-month average, multiple entries per month

Hi all

I have a Google Sheet (excel attached) where I have a column of dates, months and amounts that are aggrigated in a line chart on the right (not in attached excel doc). I would now like a function that looks down the list of amounts (column E) and, on a rolling basis (perhaps based on a =today() cell) averages the total value of payments per month in E2.

For example the total of the following 3 are:

November 2020 - £3.75
December 2020 - £48.19
January 2021 - £19.01

The average of these would be £23.65. Could I create a formula in E2 that would do that for the previous 12 months? I think it should be relatively simple, but can't work out how to do it.

Many thanks indeed.

This is perfect. Thanks so much for your help!