Hello everyone. Really struggling with something - I know this has been posted in other places, but I'm having a hard time understanding the solutions.
I'm trying to create a function (not in vba) that will count the unique IDs where it fits the criteria: Date>8/2, Date<=8/7, Hours>0, Type="Driver"
I think I can use the Sum, Frequency, If functions, but I can't seem to understand the syntax.
Any help would be greatly appreciated! Pls help!
<tbody>
</tbody>
I'm trying to create a function (not in vba) that will count the unique IDs where it fits the criteria: Date>8/2, Date<=8/7, Hours>0, Type="Driver"
I think I can use the Sum, Frequency, If functions, but I can't seem to understand the syntax.
Any help would be greatly appreciated! Pls help!
A | B | C | D | |
1 | ||||
2 | 8/2/2015 | |||
3 | 8/10/2015 | |||
4 | Driver | |||
5 | ||||
6 | ID | Type | Hours | Date |
7 | 1 | Driver | 1 | 8/1 |
8 | 2 | Passenger | 5 | 8/2 |
9 | 2 | Passenger | 2 | 8/3 |
10 | 3 | Driver | 5 | 8/5 |
11 | 4 | Driver | 5 | 8/6 |
12 | 5 | Driver | 0 | 8/7 |
13 | 5 | Driver | 2 | 8/8 |
14 | 6 | Driver | 2 | 8/9 |
15 | 6 | Driver | 0 | 8/10 |
<tbody>
</tbody>