Average upto the current month in a calendar year

[Muthukrishnan V]

Office 365

Average upto the current month

I want to find average upto the month
for this calendar year.

Cell J15 contains number: 75000. Column A5:A371
contain date in dd-mm-yy format.

Current month is Nov, i.e 11 for this calendar
year. =J15/11. I want this auto average calculation
for all the months based on dates in Column A5:A371.

Kindly advise me formula.

 

[earthworm]

Have you tried averageifs ?

 

[bebo021999]

Not clear for me. But try:
=J15/MONTH(TODAY()*MONTH(A5)
Its avg value of the month of date in A5
Drag down for date in A6,A7,...,A371