Lookup with multiple results that then need to total

[jtrethowan]

Could be a very unusual combinations as can't seem to find answer with vlookup, index, and filter but not what i wanted.

I have a table of data to source from, each line is an occasion and each delay can be broken down into up to 3 code.
Source.

The output I am looking for is then a table which will show the total number of mins from each delay code. e.g. code 32 in the example has ttl of 57 mins. I would then repeat for the other codes 93 etc. I have this table on a separate sheet.

Results

Thanks for any help in advance.

 

[ExceLoki]

this should return what you are looking for:
-------------------------------

Book1
	A	B	C	D	E	F	G	H	I	J
1	TTL Delay Mins	Code S1	Mins S1	Code S2	Mins S2	Code S3	Mins S3		Code	Total Mins
2									32	57
3	52	32	42	93	10				35	47
4	35	32	15	87	20				47	10
5									87	45
6	-2								93	45
7
8	30	87	25	93	5
9
10	47	35	27	93	20
11
12	30	35	20	93	10
13
14	57
15
16	30	47	10
17
Sheet1

Cell Formulas
Range	Formula
J2:J6	J2	=SUMIF(Table1[[Code S1]:[Mins S3]],I2,Table1[Mins S1])