March 16, 2015
April 21, 2015
December 7, 2016
The solution given by Frans is better than the one I am to provide here, but I give you my reply just so you can see how this can be solved in different ways. There are of course other solutions that can be used too.
My approach here is to create one worksheet per month, not having all data in one table or range as in the example you provided. Reason to that is to visually make it more easier to view it all. The downside is that this approach usually also means more work if you want to create dynamic charts and such.
In the attached file you see two worksheets, the first one I have used a range as a list, the second I have used a table as a list. The formula is the same, apart that with a table you get the option to add a total row at the bottom of table. Check out the sample file and try out for yourself.