0-10,

=SUMPRODUCT(--(Sheet3!$E$2:$E$20<""),--(LEFT(Sheet3!$F$2:$F$20,LEN($A2))=$A2),--(Sheet3!$E$2:$E$20<=--"0:10"))

10

=SUMPRODUCT(--(Sheet3!$E$2:$E$20<""),--(LEFT(Sheet3!$F$2:$F$20,LEN($A2))=$A2),--(Sheet3!$E$2:$E$20--"0:10"))

and just copy down.

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
Example sheet 3 On Time Performance

A B C


Route 0-10 +10

535S 1 1
401S 1
535S 0
511S 0
404n 0
404s 0



Example sheet 2

A B C D E
F


Run Vehicle Time Actual Diff Schedule

924 0 4:48 4:59 0:11 535S0448
208 0 5:13 5:14 0:01 401S0459
904 0 5:18 5:20 0:02 535S0518
908 0 5:25 511S0518


I'm using sheet 3 to record the on time performance according to the
scheduled time on sheet 2.
Sheet 2 is to record the times vehicles pass a specific location. Column C
is a set time, the vehicles are not allowed to pass until that time or
later.
Column D is used to enter the actual time the vehicle's pass.
Column E on sheet 2 is set =D-C to record the difference of set time and
actual time they pass. If the actual time the vehicle's pass is within 0
thru
10 minutes of the set time I record this in sheet 3 column B. If the
actual
time the vehicle's pass is greater than 10 minutes I record this on sheet
3,
column C.
I'm trying to have sheet 3 linked to sheet 2 so when the vehicle's pass
and
I enter the time on sheet 2 column D, sheet 3 will do the count from that
entry, and place the count in the proper column.

There is more info on this in my other post "Tracking sheet Help"

hope this makes sence. Also my time format is set to, Time 13:30


"Bob Phillips" wrote:

I think we need (a lot) more detail than that.

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
Tracking sheet help, i'm stuck.