Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

EXCEL - Count if?

Status
Not open for further replies.

shmoes

MIS
Apr 24, 2003
567
CA
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

 


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]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top