Excel 2007 : COUNTIF and IF

[Deap]

Hi Guys,

This is probably a simple one for some of you, I know what I'm trying to say but not sure of the exact due to numerous arguments format.

I have a list of guys on my team and several status codes for jobs they complete, the only format we can have for recording this data is that the enter their "Name" "Job Reference" and "Status Code" for each Job,

I know I can calculate my findings using a pivot table but I'd rather just copy the data to a separate sheet and count them dynamically.


I'd like to

COUNTIF ('Sheet 2'!A:A)="value of, current Sheet Cell A2" & ('Sheet 2'!C:C)="value of, Current Sheet Cell B1"

I know this is half function half text, sorry. it just goes to show how I don't understand the calculation.