Query Count When Another Field Value Is Equal to Given Variable

[geospatial]

I am trying to run a query where I have 4 columns.

Column 1: Key Number (List of Unique Key Numbers)
Column 2: Keys Signed Out (Keys are said to be signed out if they employeeFirstName Is Not Equal to Extra Key)
Column 3: Keys In Inventory (Keys are in inventory if employeeFirstName is Equal to Extra Key)
Column 4: Total Key Count (Adding the row from Column 2 and Column 3

Ive used column criteria before, but that was when specifically wanting to filter by data in the one particular column you are setting criteria on. I am not sure how I would set criteria to only count the number of Keys that are set to a given name in another field. Any thoughts?

 

[alansidman]

Providing sample data: Before and After scenarios will help significantly. Use the XL2BB function.