3 Replies Latest reply: Sep 27, 2013 6:12 AM by Peter Raijmakers RSS

    Count/sum single value in multiple lines

    Peter Raijmakers

      Hello

       

      Please look at the example to better understand my question.

       

      I want to do a sum(count) of the number of errors per section. The sections are reoccurring over time.

       

      DATA:

      IDDatesectionnumber of errors in section
      11A1
      21A1
      31A1
      41A1
      51A1
      61B0
      71B0
      81B0
      91C2
      101C2
      111C2
      121C2
      132A0
      142A0
      152A0
      162B2
      172B2
      182B2
      192B2
      202C1
      212C1
      222C1
      232C1

       

      TABLE that I want to produce

      sectionerrors
      A1
      B2
      C3
      total6

       

      I hope someone can help me with this.