I have a work book to keep track of route times.
Each sheet has a scheduled time, an actual time, and a calculated column for
the difference.
The route numbers are the same throughout the day, and they are separated by
a run number.
Im trying to do a summary on each route counted, and separate them by
whether they are within 10min of the scheduled time or over 10min late.

This is what I have so far but its not working.

=SUMPRODUCT(--(LEFT('4th'!$F$3:$F$96,4)='4th'!G4),--(ABS('4th'!$C$3:$C$96-'4th'!$D$3:$D$96)*SIGN('4th'!$D$3:$D$96-'4th'!$C$3:$C$96)<=--"0:10:59")--('4th'!$D$3:$D$96<""))

A B C D E F
G H I
Run # Location Sched time Actual Diff Schedule Route # 0 -10
11+ 930 Hew/Virg 9:10 ### 510S0910 414n
970 Ash Way 9:11 ### 511S0911 414s
900 Sodo/Royal 9:15 ## 510N0915 510n
952 10th/102nd 9:15 ### 535N0915 510s
800 LTC 9:18 ### 535S0918 511n
912 Sodo/Royal 9:26 ### 511N0926 511s
246 Ash Way 9:26 ### 511S0926 535n
960 Hew/Virg 9:40 ### 510S0940 535s
958 Ash Way 9:41 ### 511S0941
904 Sodo/Royal 9:45 ### 510N0945
920 10th/102nd 9:45 ### 535N0945
908 LTC 9:48 ### 535S0948
938 McCull 9:50 ### 414S0950
936 Sodo/Royal 9:56 ### 511N0956
902 Hew/Virg 10:10 ### 510S1010
966 Ash Way 10:11 ### 511S1011