Count occurrences based on multiple conditions without creation of additional columns

All,

Simplified version of my current problem,

In Sheet1, there are 4 columns Column A=Driver, Column B= Start Time (DD:MMM:YY HH:MM), Column C=End Time (DD:MMM:YY HH:MM) and Column D= Destination

In Sheet2, I am trying to count for number of instances driver has taken to reach a destination in less than 240 minutes.

I have used the following formulas but not successful.

Formulas Used:

1) Countif(((Sheet1!C:C-Sheet1!B:B))*1440), "<="240,Sheet1!A:A,"="AAA)... Tried CTRL+SHFT+ENTR for array as well

2) Sumproduct((Sheet1!C:C-Sheet1!B:B)*1440) <= 240, Sheet1!A:A,="AAA").... Tried CTRL+SHFT+ENTR for array as well


Data in sheet1 will be replaced everyday so I cannot give cell addresses in the formula but would have to consider the whole column. The data also has headers in the first row of sheet1.

I am multiplying the time values with 1440 to get the difference in minutes.

I would really appreciate some help in this. Thank you.