Currently using countif function but not sure if its the coreect funtion for application

[PorshaReed]

Example Table

Dept Line Station JCI/Temp DL/IL Leave Flex
Fabrication Bending MPL1000_1004 Assy Tech JCI DL
Fabrication Bending MPL1000_1004 Assy Tech JCI DL FLEX
Fabrication Bending MPL1000_1004 Die Setter JCI DL STD
Fabrication Bending MPL1001_1002 Assy Tech Temp DL
Fabrication Bending MPL1001_1002 Die Setter JCI DL FLEX
Fabrication Bending MPL1001_1002 Die Setter JCI DL
Fabrication Bending MPL1001_1002 Die Setter JCI DL
Fabrication Bending MPL1000_1004 Die Setter JCI DL
Fabrication Bending MPL1003 Die Setter JCI DL
Fabrication Bending Tab_Bender Assy Tech JCI DL
Fabrication Bending MPL1003 Assy Tech JCI DL FMLA
Fabrication Rivet_Weld R&W Team Leader JCI IL

I am currently using countif function but is not always returning the right result. For example, I want to count the number of 'MPL1001_1002 Die Setter"s minus any that are listed on leave (STD/FMLA) and/or FLEX.

Please help!

[bebo021999]

What is your current formula? Couls you please attach a sample file?

[PorshaReed]

Sample Sheet.xlsx

I would want to count the number of leaders who do not have fmla/std and/or flex in the same row.

The function that I was using was countif(e6:e17,"Leader") I havent figured how to make the formula dependent on whether the person was classified with 'Leave' or 'Flex'. (Basically any row with Leave or Flex selected would not count in the end total.

[Jonmo1]

Try

=COUNTIFS(E6:E17,"Leader",H6:H17,"",I6:I17,"")