# Count Question

#### siouxprincess

##### New Member
How do I count how many "Not Determined" between 00:00:00 and 05:00:00 ?

Column A:
A1: Not Determined
A2: No Problem Found
A3: Not Determined
A4: Operator Error
A5: Operator Error
A6: Not Determined

Column B:
B1: 00:06:00
B2: 05:35:01
B3: 50:56:45
B4: 01:00:01
B5: 20:00:00
B6: 01:26:35

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

#### LxQ

##### Well-known Member
=SUMPRODUCT(--(A1:A6="Not Determined"),--(B1:B6>=0),--(B1:B6<=0.20833))

#### LxQ

##### Well-known Member
actually, make that <0.20834 just so it would include 5:00:00 as well..

Replies
3
Views
201
Replies
1
Views
575
Replies
3
Views
619
Replies
15
Views
448
Replies
131
Views
3K

1,191,310
Messages
5,985,915
Members
439,987
Latest member
g00ber

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