Adding rows with Control Number that only repeat 3 times: Formula

Hi,

I'll try to explain this the best I can. What I have here is a time study. Teachers (which are the control numbers) fill out bubble sheets, then I run them through a scanner. After dissecting the data from the scanner and formatting it to my liking i get this below.

Each teacher/staff member fills out three sheets per quarter. Each letter (bubble) counts as a 0:15 min period of time. Only K thru Q counts as billable time, which I've created a formula to count those letters (column 3). But to be countable each control number has to have three cycles 201,202,203.

So I need something that can take each control number that has three cycles and add their # of 0:15 together.

The italic row below only has one cycle for that control number, so that needs to be deleted or ignored.

Ultimately I would like the results on a separate sheet.

This is only a part of the file, there are over 1000 different control numbers.

QuarterCycle | ControlNumber | # of 0:15 | Admin1 + Admin2
201	4010101	8	QQJJPJJJPPJJJJJJJJJJPJJJJJJJQJQJJJ
202	4010101	6	DDQJJDDDDDDDDDDDDQQQQQJJJJJJJJDDDDDDDD
203	4010101	7	DDQJJDDDDDDDDDDDDDJJQJJJJJJJJQQQQQ
201	4010102	4	JJJJQJJJQJJJJJJJJJJJJJJJJQJJJJJJQJ
202	4010102	14	JJJJJJJJJ              PPPPPPPPPPPPPPJJJJJJJ
203	4010102	12	DDDDJJDDDDDDDDQQQJJJJJJJQQQQQQQQQD
201	4010103	16	CQQQQJJJJQQQQQQJJQQJJJJJJJQQQQCCCCC
201	4020101	0	CCCJJJCCCCCCCCCCCCCCCCCCCCCCCCCCC
202	4020101	0	CCCJJJCCCCCCCCCCCCCCCCCCCCCCCCCCC
203	4020101	0	CCCJJJCCCCCCCCCCCCCCCCCCCCCCCCCCCC
201	4020103	0	JJJJDDJJJJJJDJJJJJJDJJJJJJJJJJJJ
202	4020103	0	JDDJJJJJJJJJDJJJJJJJJJJJDJJJJDJJ
203	4020103	1	DJJDJJJJJJJJJJDJJJJJJJJJJJJQJJJJD
201	4020105	15	CCCCCCKKKKKKKCCCCCCCCKKKKKKKKC
202	4020105	0	JJCCCJJCCCCCCCCCCCCCCJJJJJJCCCCCJ
203	4020105	15	KKKKKKKCCCCCCCCCCCCCCKKKKKKKCCCCCK

I hope I explained it well enough.

Thanks,
Gman2005