EXCEL - Count if?

[shmoes]

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

 

[SkipVought]

hi,

Are there more than one event per employee?

Are there more than one job per employee?

I'd use MS Query to JOIN the two tables and then perform the counts. If Excel 2007+ then Data > Get external data > From other sources > From Microsoft Query -- Excel Files*.....


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[shmoes]

yes on both questions the only common factor is the employee. But the employee could have

I've never used MS Query before I will look into it.

Thanks

~AZ