COUNTIF and Data in Two Columns

[jt_tj_ca]

K, I have data in two separate columns. The data in question has been generated by the following formulas

column 1 = IF(COUNTIF(Sheet2!A:G,B21), VLOOKUP(B21,Sheet2!A:G,7,0),)
column 5 = VLOOKUP(B21,Sheet4!A:D,4,FALSE)

In each column there is a range of data. I need a fomula that looks at both columns(1 and 5) and returns the SUM of two separate criteria. For example:

04:47 02:56 03:52 01:51 Jeff
04:53 03:39 04:16 01:14 Lee
05:09 04:11 04:40 00:58 Lopez
05:14 00:00 02:37 05:14 Lee
05:18 03:25 04:22 01:53 Jeff
05:02 03:36 04:35 01:57 Lopez
05:37 03:23 04:30 02:14 Lopez

What I'm hoping to do is find results in the first column that are under 05:10. Then count the number of names in the last column that have results in the first column that are under 05:10. Using the example above, my results would be Jeff = 1, Lee = 1, Lopez = 2

I've tried SUMPRODUCT(--(D3:D65<"05:10Jeff Green"),--(H3:H65="Jeff ")) and SUMPRODUCT((D2:D64<"050:10")*(H2:H64="Lopez")) and finally COUNTIF(D3:D65,"05:10")+COUNTIF(H3:H65,"Jeff")

I'm officially stumped.

Any ideas?

Thanks

[shg]

Welcome to the forum, jt.

Please take a few minutes to read the Forum Rules about thread titles, and then amend yours accordingly.

Thanks.