How many, less than

[tawcoking]

I am unable to figure out how to total the number of entries where agents in column 'A' have a time of less than 00:06:00 'B'. So basically I am looking for the amount of times that each agent has a time of less than 00:06:00. Can anyone help?

A B
jsmith 00:05:24
lrogers 00:08:50
jsmith 00:03:52
jsmith 00:09:18
lrogers 00:03:01
jsmith 00:05:02

[6StringJazzer]

Let me know if this does what you need:

=COUNTIF(B:B,"<"&TIME(0,6,0))

[scottylad2]

A B Agent Count
jsmith 00:05:24 jsmith 3
lrogers 00:08:50 lrogers 1
jsmith 00:03:52
jsmith 00:09:18
lrogers 00:03:01
jsmith 00:05:02

in D1 and copied down

=SUMPRODUCT(--($T$23:$T$28<TIME(0,6,0)),--(U23=$S$23:S28))

[tawcoking]

Not quite, I know how to find all the entries with less than and all the entries with a spefic name, but I cannot figure out how to combine the two. For example, how many entries exist where jsmith has less than 00:06:00.

[DonkeyOte]

given XL2010 see COUNTIFS function

[scottylad2]

Not quite, I know how to find all the entries with less than and all the entries with a spefic name, but I cannot figure out how to combine the two. For example, how many entries exist where jsmith has less than 00:06:00.

As Donkey ote said, countifs would be better but the formula i posted does that as well