This is probably an easy one for the pros
Here is what I am trying to do.
Sheet 1 Identifies employee + Event
Sheet 2 Identifies Employee + Job number
I want to separate the events by job number on sheet 3
Example
- Job 001 = 3 Events
- Job 002 = 10 Events
I only have currently countif
=COUNTIFS(Sheet1!C:C,"event1") which gives me the total number of specific events.. but I want to drill deeper and split the events by job numbers from the other sheet. The only matching item on both sheets are the employee name/number
... thoughts?
TIA
~AZ
Here is what I am trying to do.
Sheet 1 Identifies employee + Event
Sheet 2 Identifies Employee + Job number
I want to separate the events by job number on sheet 3
Example
- Job 001 = 3 Events
- Job 002 = 10 Events
I only have currently countif
=COUNTIFS(Sheet1!C:C,"event1") which gives me the total number of specific events.. but I want to drill deeper and split the events by job numbers from the other sheet. The only matching item on both sheets are the employee name/number
... thoughts?
TIA
~AZ