# Two criteria to calculate

#### Ks1102

##### Well-known Member
Hi, experts

I wants have a formulas to found two criteria as column C = criteria and column D = time, example, found criteria “014”-“013” time.
The result on at cells A1,

Thanks

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
I'm not exactly sure what you are asking.

C=some criteria, such as "014"
D=time, such as "013"
then give me the value that's in column A?

If so, here's that formula:

I'm not exactly sure what you are asking.

C=some criteria, such as "014"
D=time, such as "013"
then give me the value that's in column A?

If so, here's that formula:

pagrender

Cells A1 = 2:00

COL C COL D
011 10:00
012 10:30
013 13:15
017 16:00
014 15:15
068 17:21
else ....

Replies
3
Views
191
Replies
23
Views
702
Replies
2
Views
189
Replies
2
Views
257
Replies
4
Views
108

1,221,406
Messages
6,159,694
Members
451,586
Latest member
khaledshahin

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