Adding columns in a row with seperators in the same column.

[Mouse123]

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.

[Richard Buttrey]

Hi, and welcome to the forum.

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

[Mouse123]

Thank you

I have attached the sheet with how I want it to look but I need the TotalsNews to work automatically when a New1 or New2 e,t,c is addded in the column.

Hope that makes sense.

Thank you very any assistance