Count/sum single value in multiple lines

[pepe2209]

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.

[tresesco]

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

[abeyphilip]

Hi Peter,

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

Regards,

Abey

EDIT - Updated with calculation for total.

[pepe2209 · Accepted solution]

Yes thanks this seems to work perfectly!

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

Thanks.