I am trying to create a template for users to fill in.

I have to count an item on a given date and record a value. I want to know this total which I can do. However on some dates the item in that same column become new and I want to total the values after it becomes new. It could become new on a number of occasions though. i.e New1, New2, New3. I will need the new totals for each New listed.
Hope that makes sense.

Date A1 A2
2/4/2014 2 5
3/5/2014 5 6
5/6/2014 New1 5
3/7/2014 5 New1
5/8/2014 6 2
5/9/2014 13 2
3/10/2014 14 New2
4/11/2014 9 6
3/12/2014 6 4

Total
Total New1
Total New2

Obviously I can add the columns manually but I don't know how to make it templated so excel knows when it sees New1 for example to add the numbers before it sees New2 and then to total the New2 columns before it sees New3.

Greatfully for any assistance.