Sumproduct help

[n1lesh]

92DDT 21:00
75DDT 22:00
7.5T 21:44
17T 22:05
92DDT 21:00
75DDT 23:58
7.5T 21:29
17T 23:25

these text strings correspond to a number:
92DDT = 98
75DDT = 75
7.5T = 15
17T = 26

HOW DO I DO A SUM ON THE COLUMN CONTAINING THE TEXT AND BE ABLE TO ONLY PICK VALUES
THAT ARE BEFORE 22:00


ANY HELP WOULD BE MUCH APPRECIATED

 

[rayk8301]

Does this help?

the first 98 being this code:
=IF(J10<$J$7,VLOOKUP(I10,$I$20:$J$23,2,0),"")
[TABLE="width: 294"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]Constant[/TD]
[TD="align: right"]22:00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]92DDT[/TD]
[TD="align: right"]21:00[/TD]
[TD="align: right"]98[/TD]
[/TR]
[TR]
[TD]75DDT[/TD]
[TD="align: right"]22:00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7.5T[/TD]
[TD="align: right"]21:44[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD]17T[/TD]
[TD="align: right"]22:05[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]92DDT[/TD]
[TD="align: right"]21:00[/TD]
[TD="align: right"]98[/TD]
[/TR]
[TR]
[TD]75DDT[/TD]
[TD="align: right"]23:58[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7.5T[/TD]
[TD="align: right"]21:29[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD]17T[/TD]
[TD="align: right"]23:25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Total[/TD]
[TD="align: right"]226[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]92DDT[/TD]
[TD="align: right"]98[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]75DDT[/TD]
[TD="align: right"]75[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7.5T[/TD]
[TD="align: right"]15[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17T[/TD]
[TD="align: right"]26[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[rayk8301]

where $j$7 is the constant, and the vlookup table are the values for those labels.