=SUMPRODUCT(--(A2:A100="F"),--(B2:B100<--"2:00:00"))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jack" wrote in message
...
Hi,

I am trying to filter a spreadsheet which lists in one column job type,
and
in the other column response time (total duration in hh:mm:ss). I have
been
trying to figure out a COUNTIF query which would allow me to obtain the
number of jobs which have a job type of 'F' for 'Fault', and which have a
response time of less than 2 hours.

If anyone can help me with this, that would be greatly appreciated.
Thanks