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

# Count/sum single value in multiple lines

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:

 ID Date section number of errors in section 1 1 A 1 2 1 A 1 3 1 A 1 4 1 A 1 5 1 A 1 6 1 B 0 7 1 B 0 8 1 B 0 9 1 C 2 10 1 C 2 11 1 C 2 12 1 C 2 13 2 A 0 14 2 A 0 15 2 A 0 16 2 B 2 17 2 B 2 18 2 B 2 19 2 B 2 20 2 C 1 21 2 C 1 22 2 C 1 23 2 C 1

TABLE that I want to produce

 section errors A 1 B 2 C 3 total 6

I hope someone can help me with this.

• ###### Re: Count/sum single value in multiple lines

With given data, how is C - 3 ? Can you please explain the logic?

• ###### Re: Count/sum single value in multiple lines

Hi Peter,

Are you looking for something like the Sum table in the attached eg.

Regards,

Abey

EDIT - Updated with calculation for total.

• ###### Re: Count/sum single value in multiple lines

Yes thanks this seems to work perfectly!

Trying to figure out the formula for myself but this helps me a lot

Thanks.