"Complex" score averaging system

I am fairly well versed in Excel but I am having a hard time getting the results I want from a spreadsheet I am trying to create. I play darts and the website that kept stats for me for several years did not renew the domain so I lost everything for the year. I am preparing for next year.

Here is what I have and what I need help with:
I am only using this chart for following my 501 games - start at 501 and throw darts till I get to zero.

First column: date (easy and done)
Second column: number of darts thrown (easy...if I throw 20 darts in a 501 game I enter 20)
Third column: points per dart: (easy...501/column 2)
Forth column: points per turn: (easy...column 2 * 3 darts)

Here is where I am having problems:
Fifth column: I want a cumulative average of all games played for a month. So if I throw a 20, 22, and 22 dart games I want to have each cell to show a cumulative of the previous games. i.e. 20+22=42 darts. Two 501 games (1002). 1002\42=23.85 darts/game. 23.85 * 3 (3 darts per turn) = 71.55 Points per turn. 42+22=64 darts. Three 501 games (1503). 1503/64=23.48 darts per game. 23.48*3=70.44
Sixth column: Cumulative average for the year. Same as above but I want to have an average for the year.

I don't have a problem with the math. The problem I have is preventing formatting these enormous lines of b2+b3+b4+b5 et al.

Any formula formatting is greatly appreciated.

I think I put the spreadsheet in the reply.

leenich: What you show there is really close to what I want.

I want to add additional data as time goes by and I want the pivot table to be able to recalculate. I am looking for a monthly average and a year to date average. That also means having the spreadsheet figure out how many games I played in the month.
I was trying to redo the pivot table myself and for some reason the spreadsheet would not allow me to save. Something about formula errors.
Attached is my current sheet and a screen shot of what I was trying to view for a pivot table.
I hope I got the attachments included.

Try

See table in H:M

In I2

=SUMIFS(B:B,$A:$A,">=" &$H2,$A:$A,"<=" &EOMONTH($H2,0))

in J2

=IFERROR((COUNTIFS($A:$A,">=" &$H2,$A:$A,"<=" &EOMONTH($H2,0))*501)/SUMIFS($B:$B,$A:$A,">=" &$H2,$A:$A,"<=" &EOMONTH($H2,0)),"")

in K2

=IFERROR((COUNTIFS($A:$A,">=" &$H2,$A:$A,"<=" &EOMONTH($H2,0))*501)/SUMIFS($B:$B,$A:$A,">=" &$H2,$A:$A,"<=" &EOMONTH($H2,0))*3,"")

in l2

=IFERROR((COUNTIFS($A:$A,">=" &$H$2,$A:$A,"<=" &EOMONTH($H2,0))*501)/SUMIFS($B:$B,$A:$A,">=" &$H$2,$A:$A,"<=" &EOMONTH($H2,0)),"")

in M2

=IFERROR((COUNTIFS($A:$A,">=" &$H$2,$A:$A,"<=" &EOMONTH($H2,0))*501)/SUMIFS($B:$B,$A:$A,">=" &$H$2,$A:$A,"<=" &EOMONTH($H2,0))*3,"")

The yearly cumulative for May 2018 is not calculating correctly.

Month TTL Dart PPD PPT *** PPD *** PPT
May-18 516.00 13.59 40.78 1.45 5876.95

What is the entry for L6 and M6?

I added dates and games to May but the year to date did not calculate correctly.

The results agree: you had an extra date in May which "upset" my formulae.

Will I be able to add dates to the sheet and it calculate everything?
Eventually I will want to start over in 2019. Will these formulas work next year?

Yes it will work for all months but you need to change the dates in column H as required.

June calculations are not correct. Please help.

I guess I don't understand what you are talking about. At the top of the document is a pivot table that calculates each month. L7 is not calculating correctly. The date I put in Column A is different for each time I practice.

And I guess I could use some instruction on how to fix this myself in the future.

The original pivot table shows for January, February, March, April, and May so a monthly and yearly (Cumulative) points per turn. The monthly PPT is correct. The yearly (Cumulative) is not calculating correctly.

JeteMC: I did what you suggested and it shows correctly. That looks right. My next question is how do I get the rest of the year to calculate correctly? Do I need to drag that same formula from L8 to L13? I am going to start entering practice for July and I want the cumulative calculation to continue.

Thank you for your help.