# Sumproduct help

#### n1lesh

##### Board Regular
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

### Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Does this help?

Code:
``````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]``````

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

Replies
2
Views
1K
Replies
4
Views
281
Replies
1
Views
312
Replies
1
Views
614
Replies
2
Views
515

1,203,562
Messages
6,056,086
Members
444,845
Latest member
dpkane512

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back