Try

=COUNTIF(DrivingViolations!F:F,A3)

VBA Noob